Take the SQL Server Index Quiz

Take the SQL Server Index Quiz

PASS Data Community Summit via YouTube Direct link

Intro

1 of 29

1 of 29

Intro

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Take the SQL Server Index Quiz

Automatically move to the next video in the Classroom when playback concludes

  1. 1 Intro
  2. 2 Technical Assistance
  3. 3 PASS SUMMIT 2015
  4. 4 The best way to learn about indexes
  5. 5 Get your pen and paper ready!
  6. 6 When creating a Non-Clustered Index, the size of any included columns counts towards the 900 byte size limit
  7. 7 Non-Clustered Index B+ Tree
  8. 8 Can SQL Server use this index for this query? CREATE INDEX ix_creationbute on dbo. Posts CreationDate
  9. 9 Looking at the index...
  10. 10 SQL Server can read backwards!
  11. 11 Look at the query
  12. 12 Functions aren't great
  13. 13 8,745 logical reads (each)
  14. 14 How you write the query matters
  15. 15 The Query Optimizer knows how fragmented each index is.
  16. 16 The optimizer does NOT consider...
  17. 17 But the optimizer DOES consider...
  18. 18 How many rows with NULL values can be in an index defined as unique?
  19. 19 Time to get controversial
  20. 20 Filtered indexes are interesting for this!
  21. 21 Which of the following filtered index definitions is valid?
  22. 22 This one's tricky!
  23. 23 Filtered indexes are very cool
  24. 24 When creating an Indexed View, which of the following tasks is required, no matter what? A. Make sure all the underlying tables have Clustered
  25. 25 If you answered, "rewrite your queries to force them to use the view"...
  26. 26 No matter what, you must always...
  27. 27 Indexed views are magical
  28. 28 Join me for SQL Server Index Therapy
  29. 29 Like What You've Heard?

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.