Partitioning

Course Category: Partitioning

• Why Table Partitioning Does Not Speed Up Query Performance - With One Exception (52 minutes)

  7 Lessonsin Partitioning

  

  Learn why SQL Server's table partitioning feature won't make your queries against disk-based rowstore indexes faster-- and may even make them slower.

• Execution Plans: Partitioned Tables & Columnstore Indexes (1 hour 30 minutes)

  9 Lessonsin Partitioning

  

  Use execution plans to build your knowledge of partitioned tables and columnstore indexes.

• Problem Queries in Table Partitioning (1 hour 30 minutes)

  14 Lessonsin Partitioning

  

  Learn how to identify and fix the top query patterns that can go wrong after you implement table partitioning.