22-25 April 2026 
SQLBits 2015
Common Pitfalls When Analyzing Execution Plans
In this session you'll learn how to analyze execution plans efficiently, how to track the real bottleneck quickly, and how to avoid some common mistakes that will save you a lot of time and frustration…
The most powerful tool when tuning a single query or a single batch is the execution plan. By analyzing the execution plan of a query, you can learn all you need to know about how the query processor chose to execute the query, what causes the execution to take so long, and what you can do in order to make it run faster.
But there are several common pitfalls that you should be aware of when analyzing an execution plan. These pitfalls can be very misleading, and they might cause you to spend your tuning effort in the wrong direction. By understanding these pitfalls and avoiding them, you can save a lot of time and effort, and you can get your query to run faster - faster…
But there are several common pitfalls that you should be aware of when analyzing an execution plan. These pitfalls can be very misleading, and they might cause you to spend your tuning effort in the wrong direction. By understanding these pitfalls and avoiding them, you can save a lot of time and effort, and you can get your query to run faster - faster…
Speakers
Guy Glantser's previous sessions
The Most Important Performance Factor in SQL Server and Azure SQL
If you care about your database performance, then make sure you take care of your statistics. Join this session to learn why it is so important, and how to do it right.
How to Make Sure Your SSIS Packages Will Never Fail
If you never have errors in your SSIS packages, then you don't need to attend this session. But if you want your packages to be reliable and safe, and to handle errors appropriately, then this session is for you.
Common Pitfalls When Analyzing Execution Plans
In this session you'll learn how to analyze execution plans efficiently, how to track the real bottleneck quickly, and how to avoid some common mistakes that will save you a lot of time and frustration…