SQL Statement Tuning with Query Optimizer Strategies
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.
Download it! Download the zipped slide deck here (uncompresses in MS-Power Point 2007 format).
Rate it! Rate my session and offer feedback here.
Read it! Download the white paper detailing everything in the slide deck and more when it becomes available later this year. (It’s currently in review with Quest MarCom.)