PASS Community Summit 2008: Spotlight Session (Database Administration)

Guiding Your Query Plans

Kalen Delaney

Session Details

Changing your production code to add query hints can be problematic for any number of reasons. You might be using a vendor application that doesn't allow changes, or you might have a long approval process in your organization that must be strictly adhered to. And until (or unless) these hints can be added, your users will suffer the consequences of poorly performing queries. SQL Server 2005 introduced the ability to create Plan Guides which provide SQL Server's execution engine with guidelines for processing your queries, without having to change the actual code. In this session we'll look at the uses and best practicing for Plan Guides, and the details of how to set them up and how they work. We'll also look at the enhancements to plan caching, query hints and Plan Guides in SQL Server 2008.

Register Now for PASS Community Summit 2008!