Inside Microsoft® SQL Server™ 2005: T-SQL Querying

Chapter 3. Query Tuning

In this chapter:

Sample Data for This Chapter

Tuning Methodology

Tools for Query Tuning

Index Tuning

Preparing Sample Data

An Examination of Set-Based vs. Iterative/Procedural Approaches, and a Tuning Exercise

Additional Resources

Conclusion

This chapter lays the foundation of query tuning knowledge required for both this book and Inside Microsoft SQL Server 2005: T-SQL Programming. (For brevity, I’ll refer to the programming book as Inside T-SQL Programming, and to both this book and Inside T-SQL Programming as "these books.") Here you will be introduced to a tuning methodology, acquire tools for query tuning, learn how to analyze execution plans and perform index tuning, and learn the significance of preparing good sample data ...