22-25 April 2026 
Around the world (of query plan operators) in 50 minutes
2011TL; DR
This session will take a look at query plan operators, what they are, what they each do, why they get chosen and also how to avoid using them when they perform badly. This will be held mainly in management studio with lots of examples
Session Details
Ever looked at a query plan and thought, "what does that little operator do?" or "why has the optimiser chosen that one?" or even "why is that one operator taking up such a large % of my plan?!"
In this tour of the query plan operators we'll look at what each of them do, how each of them work, why the optimiser chooses them for a specific task and in what circumstances and why sometimes they perform badly. We will also look at how to encourage the optimiser how to choose the best operators for the job by changing the way the code is written.
Held mainly in management studio using lots of code and examples to make this session easier to follow