Understanding Query Cache and Query Plans

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.