Why Partitioning Is Not A Performance Feature In SQL Server
Going Further
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that, and need to solve database performance problems quickly. You can also get a quick, low cost health check with no phone time required.
Thank you for your content! I get that data management is the first, best benefit of partitioning. But isn’t it fair to also say that performance improvement can be achieved thru partitioning if the access patterns take partition elimination into account?
You can get the same improvement by having an equivalent index arrangement on the non-partitioned table.
It’s sort of like rebuilding indexes to update statistics. You’re doing the most expensive possible thing for a side effect.