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.
-
-
Tuning A Stored Procedure - SQLChallenge (1 hour 10 minutes)
Identify which statement is slowing down our stored procedure the most, then tune the code to speed it up.
-
How to Decode Memory Pressure (4 hours)
In this 4 hour webinar recording, I put a SQL Server under memory pressure.
-
Deduplicate Indexes - Level 1 SQLChallenge (56 minutes)
Can you safely de-duplicate the indexes on this table?
-
XEvents SQLChallenge: Create an Extended Events Trace (55 minutes)
Whoops, we've got a problem with our Query Store! Can you set up an XEvents trace to get details?
-
How To Decipher CXPACKET Waits and Control Parallelism (4 hours)
Learn how to configure parallelism and how to interpret tricky CXPACKET waits.