SQL Server 2005 introduced new types of Query Plans and how Query Plans can be used as query hints. In this session we will do a deep-dive into Query Plans, looking at how Query Plans are stored and how to interpret Query Plans. We will also look at different system management vies who can help developers and DBA's to better understand what goes on with query plans and subsequently write better performing queries.
Presented by Niels Berglund at SQLBits III
WMV Video 246 MB