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.
Flex your T-SQL: you’re challenged to write four different (but related) queries in this query writing challenge.
Tune a stored procedure to make the best use of the given indexes while returning the same results.
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 to use this Query Store feature to identify and stabilize problem queries.
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?