It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. If your browser does not support JavaScript, click here for a page that doesn't require javascript.

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.