Summary
In this chapter, you looked at how to optimize the performance of queries in SQL Server 2005. You started by looking at the different categories for poor query performance and learned how you can use the Database Engine Tuning Advisor to quickly tune your SQL Server 2005 database solution.
We then covered different techniques that you can use to help you identify potentially poorly performing queries.
Next we discussed what execution plans are and how to generate and analyze them. We provided some tips on what to watch out for in execution plans and general tips for optimizing the performance of poorly performing queries.
We then covered the importance of maintaining and optimizing indexes for query performance. You looked at what index ...
Get MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
