Around the world (of query plan operators) in 50 minutes

2011

TL; 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

3 things you'll get out of this session

David Morrison's previous sessions

Introduction to PowerApps

An overview of PowerApps and the platform

Query Plans Deep Dive

An in depth look at query plans and the query optimiser

Daves SQL Fun Time Hour (Plus a bit)

In this session we'll take a look at a wide variety of topics, from useful and little known TSQL coding constructs to best case indexing advice and a whole lot more.

SQL Tips, Tricks and Misconceptions

In this session we'll take a look at some nice bits of TSQL coding to resolve troublesome coding problems. We'll also look into writing code to make use of some TSQL features that are under used in daily coding.

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

The Dark Arts-a.k.a Performance Tuning, indexing and query plans

This session will cover the "Dark Arts" of SQL Server namely performance tuning. Rather than a traditional look at query tuning it will focus on common misconceptions and a look a why sometimes you get query plans that do "odd" things