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)


Learn Indexing by Solving Problems (7 hours 23 minutes)

Learn Indexing by Solving Problems (7 hours 23 minutes)

SQL Server asks for a lot of indexes — but it does NOT always ask for the right index!

You need to know the essential principles of index design to create the best nonclustered index, filtered index, or indexed view to speed up your critical queries.