Lies, Damned Lies And Statistics. Making The Most Out of SQL Server Statistics
Do you want to know why the Query Optimizer chooses one execution plan
Maciej Pilecki is a SQL Server Most Valuable Professional (MVP), Microsoft Certified Master in SQL Server 2008, Microsoft Certified Trainer and Senior Consultant with Project Botticelli. He has many years of international experience in Microsoft SQL Server database development, optimization and troubleshooting. He spends most of his time travelling around the world either advising his many customers on how to improve performance and reliability of their databases, or sharing the lessons learned with conference and user group audiences worldwide, where he is a popular and highly rated speaker. His favourite topics are the internals of the SQL Server database engine, including SQLOS, Storage Engine and Query Optimizer and Performance Tuning.