Around the world (of query plan operators) in 50 minutes
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
Dave Morrison is senior BI consultant for Itelligence. Having worked in the IT industry for around 15 years his main area of expertise is SQL Server, namely TSQL, query optimisation, indexing, performance tuning and internals etc.
The video is not available to view online.