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