Title: SQL Statement Tuning with Query Optimizer Strategies
Abstract: The SQL Server query optimizer is the single most important technology within the query processing engine. It decides exactly how any given SQL statement is executed. If you want to write fast SQL statements with the least amount of contention on other sessions, you need to have a good understanding of how the query optimizer works. This session teaches you how the query engine works using a broad variety of examples that are examined in great detail.
Prerequisites: Beginning SQL query writing skills
Rate it! Rate my session and offer feedback here.