PASS Community Summit 2009: Post-Conference Sessions (Database & Application Development)
Return to Session Listings
Query and Index Tuning for SQL Server 2005 and 2008
Itzik Ben-Gan (Solid Quality Mentors)
This seminar teaches you how to optimize problematic queries by tuning indexes and writing efficient code. The seminar covers in detail internal data structures and index access methods, which are the fundamental building blocks that you need to be familiar with in order to apply query tuning and optimization. After covering those fundamental building blocks, the seminar explains how to put your knowledge into action by benchmarking various indexing strategies, analyzing their performance, and choosing the most ideal design. The seminar also teaches you how to tune and optimize your solutions by applying query revisions that can yield improvements in orders of magnitude in some cases. The seminar also explains how to get rid of cursors when set-based solutions are most appropriate, and how to identify the uncommon cases where cursors are the last resort that will yield better performance than set-based solutions.
Q&A with Itzik
Q: What’s the payoff to successfully optimizing queries and indexes? Why do you have a passion for this subject?
A: For the organization, the payoff is that they get more with less. Without good index and query tuning, you have to purchase more expensive hardware. But with good index and query tuning, you can often optimize queries so that they finish in a fraction of the time they did before optimization.
As for the tuner, you get immense satisfaction from being able to reduce the runtime and resource consumption of queries. There’s so much to learn and explore in the internals as well as in understanding the logical aspects of querying and how query plans scale. If you get into this subject deeply, it will never bore you...
Read the rest of Itzik's conversation with PASS here.
About the Speaker
Itzik Ben-Gan is a Mentor and Co-Founder of Solid Quality Mentors. A SQL Server Microsoft MVP (Most Valuable Professional) since 1999, Itzik has delivered numerous training events around the world focused on T-SQL Querying, Query Tuning and Programming. Itzik is the author of several books including Microsoft SQL Server 2008: T-SQL Fundamentals, Inside Microsoft SQL Server 2008: T-SQL Querying and Inside Microsoft SQL Server 2008: T-SQL Programming. He has written many articles for SQL Server Magazine as well as articles and whitepapers for MSDN. Itzik's speaking activities include TechEd, DevWeek, SQLPASS, SQL Server Magazine Connections, various user groups around the world, and Solid Quality Mentors' events to name a few. Itzik is the author of Solid Quality Mentors' Advanced T-SQL Querying, Programming and Tuning and T-SQL Fundamentals courses along with being a primary resource within the company for their T-SQL related activities.
See the other sessions Itzik is presenting at PASS Community Summit 2009 here.
Register Now for PASS Summit 2009!