New Course: Why Table Partitioning Does Not Speed Up Query Performance – With One Exception

Table Partitioning is Tricky Business

In this new course you will 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.

Table partitioning can absolutely be worth implementing, but it may be for different reasons than you think!

In this course, you will learn:

  • What partition elimination really does
  • Why table partitioning makes some queries trickier to optimize
  • Where table partitioning shines – and in which case it can make queries faster

The videos in this session include selected questions and answers with a live audience. In these videos, I use diagrams to visually explain the concepts involved.

Like to get your hands on code to learn?

Yeah, me too. Course downloads include scripts that quickly create, populate, and explore the example table we walk through in the course, so you can prove each concept explained in the course.

This course is now freely availabile to everyone.