Watch Brent Tune a Query in SQL Server 2025

Ever wonder how somebody else does it? In this all-demo session, watch over Brent Ozar's shoulder while he takes a slow stored procedure in the Stack Overflow database, analyzes it, and iterates over several improvements trying to make it go faster. He'll explain his thought process as he goes, and get feedback from the audience on what they'd try as well.

Learn to use sp_BlitzCache to identify which queries in a proc need tuning first Understand the use of query hints to test possible database setting changes See how to measure the overhead of query hints like recompiles