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.
Niels Berglund is a principal of SQL Develop. SQL Develop is a company specializing in database and .NET development, consultancy and mentoring.
He is also a member of DevelopMentor's technical research, curriculum development and teaching staff. At DevelopMentor he specializes in .NET system software and database areas, and is author of DevelopMentors database courses.
Niels speaks regularly at various industry conferences. He writes technical articles for the trade press and is co-author of the first book released for SQL Server 2005; "A First Look at SQL Server 2005 for Developers".
He can be reached at www.sqldevelop.com.