During this session we'll take an "under the bonnet" look at query plans in SQL server. We'll look at how the components work in different versions of SQL Server and the things to look out for that could cause you problems in your queries.

We'll also take a look at how the query optimiser makes its decisions and how to influence it to make better choices 
Presented by David Morrison at SQLBits XVI