Opinions expressed on this site are solely those of Kendra Little of Catalyze SQL, LLC. Content policy: Short excerpts of blog posts (3 sentences) may be republished, but longer excerpts and artwork cannot be shared without explicit permission.
on March 15, 2018
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.