SQLBits 2012

Query Plan Operators Deep Dive

In this session we will deep an in-depth look at some of the most common query plan operators. We'll look at what they do, how they do it and the circumstances in which they are chosen. We'll also take a look into the ups and downs of each
In this session we will deep an in-depth look at some of the most common query plan operators. We'll look at what they do, how they do it and the circumstances in which they are chosen. 

We will look at the good and bad aspects of each and why sometimes they aren't the right tool for the job.
Using lots of examples we'll investigate the usage and impact they have on your SQL Server.

Hopefully you'll walk away from this session with the knowledge which will give you a deeper understanding of your query plans