SQL Server 2008 comes with many incremental enhancements that allow you to control query plans, optimize the instance for ad hoc queries, refine the information that gets stored in the query cache, and stabilize plans when moving to a new SQL Server version or service pack. In this talk, I'll also describe a SQL Server plan behavior known as parameter sniffing and new ways to control it in SQL Server 2008.