www.sqlpass.org

Register Now



Spread the Word

ROI Justification

Sponsors

Questions?

PASS Facebook PASS LinkedIn PASS Twitter

Premier Sponsor:

Platinum Sponsor:


Become a Sponsor/
Exhibitor


Download Summit Graphics

 

PASS Community Summit 2009: Post-Conference Sessions (Database & Application Development)

Return to Session Listings


Query and Index Tuning for SQL Server 2005 and 2008

Presenter:
Itzik Ben-Gan (Solid Quality Mentors)

 

Session Details

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!

Meet The Speakers

 
 

PASS Summit 2009 Dates

Pre-Conference Seminars:
Mon, Nov 2

Welcome Reception:
Mon, Nov 2

Summit Sessions:
Tues, Nov 3-Thurs, Nov 5

Post-Conference Seminars:
Fri, Nov 6

Get more details

 
 

 


Premier Sponsor: Platinum Sponsor:
PASS Facebook PASS LinkedIn PASS Twitter  
Become a Sponsor/
Exhibitor


Download Summit Graphics
Copyright 2010 by PASS | Terms Of Use | Privacy Statement | Login