Join SQL sleuth Pinal Dave, as he examines two cases where the optimizer is the criminal that killed query performance. Together, we’ll carefully investigate the query optimizer and attempt to understand why it often behaves in a manner beyond common sense. Performance forensics aren’t for the faint of heart; join only if you have a keen desire to solve mysteries and learn advanced concepts of the query optimizer.
Speakers
SQL Authority’s Pinal Dave is a SQL Server performance tuning expert and an independent consultant. He has authored 12 SQL Server database books, 30 Pluralsight courses and has written more than 5,000 articles on database technology on his blog at https://blog.sqlauthority.com. Whether you need help with a specific query plan or want general tips on boosting SQL Server performance, Pinal has you covered.