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