Category SQLChallenges

• The Idempotent TSQL SQLChallenge (28 minutes)

  2 Lessonsin SQLChallenges, Writing TSQL

  

  In this challenge, you get multiple TSQL statements and are challenged to make them rerunnable.

• Who Made That Schema Change? An Event Notification SQLChallenge (27 minutes)

  2 Lessonsin DBA, SQLChallenges

  

  Event Notifications have pros and cons -- learn 'em both in this challenge.

• Who Made That Schema Change? A DDL Trigger SQLChallenge (28 minutes)

  2 Lessonsin DBA, SQLChallenges

  

  Take a crack at writing a DDL Trigger to track schema changes.

• A Query Writing SQLChallenge: The Most Unique Names (23 minutes)

  2 Lessonsin SQLChallenges, Writing TSQL

  

  Flex your T-SQL: you’re challenged to write four different (but related) queries in this query writing challenge.

• A Dynamic SQLChallenge (32 minutes)

  2 Lessonsin SQLChallenges, Writing TSQL

  

  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 the 'Peak Years' Procedure - SQLChallenge (52 minutes)

  2 Lessonsin Query Tuning, SQLChallenges

  

  Tune a stored procedure to make the best use of the given indexes while returning the same results.