Tune the 'Peak Years' Procedure - SQLChallenge (52 minutes)

Tune a stored procedure to make the best use of the given indexes while returning the same results.
Tune a stored procedure to make the best use of the given indexes while returning the same results.
Identify which statement is slowing down our stored procedure the most, then tune the code to speed it up.
In this 4 hour webinar recording, I put a SQL Server under memory pressure.
Can you safely de-duplicate the indexes on this table?
Whoops, we've got a problem with our Query Store! Can you set up an XEvents trace to get details?
Learn how to configure parallelism and how to interpret tricky CXPACKET waits.