SQL Server: Optimizing SQL Server Query Performance

November 2007

When you optimize database performance, tuning individual queries is as important as tuning server hardware and software configurations. Even one runaway query can bring a database to its knees. Here’s a guide to generating, analyzing, and tweaking execution plans to optimize the performance of your SQL Server queries.