Execution Plans and the SQL Server Query Optimizer - Paul White, SQL Kiwi
Effective T-SQL query tuning requires an understanding of SQL Server's query optimizer and the execution plans it produces. Join SQL Server MVP Paul White for an information-packed session covering both these crucial areas. The first part of the session will give you an overview of how the optimizer works, and what you can do to get the best from it. The second part covers the main things you need to know about execution plans, including some of the most common mistakes made when reading them. Everyone from novice to expert will find something new and interesting in this talk.