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.