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.
-
Index Design SQLChallenge - One Year Wonders (50 minutes)
This indexing challenge has three levels of difficulty. Can you design the best index?