The Idempotent TSQL SQLChallenge (28 minutes)

In this challenge, you get multiple TSQL statements and are challenged to make them rerunnable.
In this challenge, you get multiple TSQL statements and are challenged to make them rerunnable.
Event Notifications have pros and cons -- learn 'em both in this challenge.
Take a crack at writing a DDL Trigger to track schema changes.
Flex your T-SQL: you’re challenged to write four different (but related) queries in this query writing challenge.
You need to write a single query loop that calls procedures across multiple databases in this SQL Challenge. What’s the most efficient way to do it?
Tune a stored procedure to make the best use of the given indexes while returning the same results.