Posted on

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

Table Partitioning is Tricky Business

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.

If you’ve already subscribed, you already have access to this course: dive right in.

If you’re ready to join, sign up here!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.