Courses by Topic

#Database administration (6) #Index design and tuning (7) #Locking and blocking (8) #Partitioning (3) #Query tuning (10) #Sqlchallenges (12) #Ssms and user tools (1) #Writing tsql (5)


The Idempotent TSQL SQLChallenge (28 minutes)

The Idempotent TSQL SQLChallenge (28 minutes)

When writing TSQL, it’s often useful to make your TSQL idempotent – a fancy word, which in the case of databases really just means: you can run the command again and again and it will make sure that you have the intended effect, without causing problems by being run more than once.

A Dynamic SQLChallenge (32 minutes)

A Dynamic SQLChallenge (32 minutes)

In this challenge, you are tasked with editing a stored procedure to gather data from multiple databases. What’s the most efficient way to do it? Try your hand at the challenge, then check out three different suggested solutions.