A Query Writing SQLChallenge: The Most Unique Names (23 minutes)
Flex your T-SQL: you’re challenged to write four different (but related) queries in this query writing challenge.
-
-
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.
-
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?
-
Auto Tuning with Automatic Plan Correction In Query Store (1 hour 8 minutes)
Learn to use this Query Store feature to identify and stabilize problem queries.
-
The Case of the Slow Temp Table: A Performance Tuning Problem (50 minutes)
Why would using a temp table cause a stored procedure to slow down dramatically and use massively more logical reads, compared to a permanent table?