-
Module 2: Table and index structures
11 Lessons-
StartFiles, extents, and pages
-
StartWhat is a heap?
-
StartTables as heaps
-
StartWhat is a clustered index?
-
StartTables with clustered indexes
-
StartNon-clustered indexes
-
StartNon-clustered indexes over heaps
-
StartNon-clustered indexes over clustered indexes
-
StartLab 2: Table and index structures
-
StartLab 2: Answers
-
StartQuiz 2: Table and index structures
-
-
Module 4: Covering queries with indexes
10 Lessons-
StartLookups
-
StartCost of lookups
-
StartCovering indexes
-
StartIncluded columns
-
StartNotes on included columns
-
StartClustering key as an included column
-
StartIndexes for queries that join multiple tables
-
StartLab 4: Covering queries with indexes
-
StartLab 4: Answers
-
StartQuiz 4: Covering queries with indexes
-
-
Module 5: Clustering keys and data types
11 Lessons-
StartChoosing a clustering key
-
StartIntegers and big integers
-
StartIdentity columns
-
StartSequences
-
StartString values
-
StartBits (boolean values)
-
StartFiltered indexes
-
StartUnique identifiers (GUIDs)
-
StartLab 5: Clustering keys and data types
-
StartLab 5: Answers
-
StartQuiz 5: Clustering keys and data types
-
-
Module 6: Index characteristics
12 Lessons-
StartIndex selectivity and density
-
StartColumn order within an index
-
StartAscending vs descending
-
StartIndex uniqueness
-
StartIndex depth
-
StartStatistics
-
StartIndex fragmentation
-
StartHeap fragmentation
-
StartFILLFACTOR and PAD_INDEX
-
StartLab 6: Index characteristics
-
StartLab 6: Answers
-
StartQuiz 6: Index characteristics
-
SQL Server Indexing for Developers and DBAs
SQL Server indexes not working as expected? Learn how they really work and how to design effective ones.
Course Summary
Need to know any of the following? Need to fix the situation fast?
- How SQL Server indexes work
- How to design SQL Server indexes
- Why SQL Server seems to be ignoring the indexes that you designed
- How data type choices affect indexes
- If filtered indexes would work better in your application
- How to check whether or not SQL Server "likes" your index
- How to avoid having too many indexes
- Which indexes you can remove
Dr Greg Low is an international consultant, developer and trainer. He has been working in development since 1978, holds a PhD in Computer Science and a host of Microsoft certifications. Greg was the first certified master for SQL Server world-wide. He is the Managing Director for SQL Down Under, a Data Platform (SQL Server) MVP, host of the popular SQL Down Under podcast series, and a member of the Microsoft Regional Director program.
Course Curriculum
Course Pricing
-
$195 USD
Enroll Now