Why Table Partitioning Doesn’t Speed Up Query Performance (video)
Learn why SQL Server’s table partitioning feature doesn’t make your queries faster– and may even make them slower.
In this 20 minute video, I’ll show you my favorite articles, bugs, and whitepapers online to explain where table partitioning shines and why you might want to implement it, even though it won’t solve your query performance problems.
Ready to Dig In? Here are the Links Discussed in the Video
Gail Shaw’s SQL Server Howlers – “I Partitioned my Table, but My Queries Aren’t Faster.”
Remus Rusanu’s Stack Overflow answer – “Partitioning is Never Done for Query Performance.”
SQL CAT Team – Diagnosing and Resolving Latch Contention
Kendra Little on the Brent Ozar Unlimited blog – “Why is this Partitioned Query Slower?”
Books Online – Using Clustered Columnstore Indexes