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.
Presented by Niels Berglund at SQLBits III
  • Downloads
    Video available WMV Video 246 MB
  • SpeakerBIO
    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.
  • Video