Indexes, Partitioning & Batch Mode Quizzes

Batch mode & columnstore

Batch Mode

Columnstore Indexes

Partitioning

Elements of Table Partitioning

Disk – based rowstore

Keys vs Included Columns

Nonclustered Index Concepts

Nonclustered Index Internals

Nonclustered Index Examples – Part 1

Nonclustered Index Examples – Part 2

Unique Indexes and Unique Constraints in SQL Server

Index Maintenance