This morning, I had the honor of presenting virtually at SQLSaturday Oslo. The session title, Watch Brent Tune Queries, explains it all. Enjoy!
In the session, I used the 2018-06 Stack Overflow database, but any recent full-sized copy (not the 2010-2013 copies) will work. Here’s the query I worked with:
/* Watch Brent Tune Queries: SQLSaturday Oslo 2020 v1.0 – 2020-08-29 https://www.BrentOzar.com/go/tunequeries This demo requires: * Any supported version of SQL Server * The 2018-06 Stack Overflow database: https://www.BrentOzar.com/go/querystack (The demo will work with other versions, but only if you tweak query parameters to reproduce the estimation errors I cover