Elementary! The Curious Case of Deceptive Query Optimizer

Embark on a detective-style journey through the intricacies of SQL Server Query Optimizer in this conference talk from PASS Data Community Summit. Investigate two critical case studies where query performance has been compromised, delving deep into the Query Optimizer's behavior to understand its seemingly illogical decisions. Examine various suspects including statistics, query hints, indexes, cardinality, and compatibility as you unravel the mystery behind poor query performance. Discover why the Query Optimizer is not the culprit but rather a victim of circumstances, and uncover the true reasons behind optimization challenges. Gain advanced-level insights into Query Optimizer concepts and learn to approach performance tuning with a detective's mindset. This 72-minute session is ideal for those seeking to solve complex query optimization puzzles and enhance their database troubleshooting skills.