A Division of Technology Associates International Corporation
Maximo Blog

Performance Tuning SQL Statements: The Where Clause

October 03, 2008 in SQL by Michael Chrisman 0 Comments

In the last entry in this series, I talked about how to performance tune your SQL statement by using the FROM clause. The From clause is where you will see the biggest gain in performance and you only need to know the database and data model. However, this is not …

Read More

Performance Tuning SQL statements: The From Clause

September 25, 2008 in SQL, SQL Server by Michael Chrisman 0 Comments

I want to talk about techniques for speeding up SQL statements. As a database developer, this is the biggest thing I am asked to do improve the performance of my application. Like most developers, I have found that performance tuning SQL Statements involved some type of Voodoo magic. I have …

Read More