Link to Scripts in Demo – https://goo.gl/JCQLUm
Link to Adventure Works DB – http://msftdbprodsamples.codeplex.com/releases/view/55330
Tutorial of the Microsoft SQL Server Table Partitioning Step by Step Explained
5 Comments
Leave a Reply
You must be logged in to post a comment.
Does partitioning cause deadlock?
How to partition it by 3?
Unfortunately, this is not an apples-to-apples comparison because there are different clustered indexes on both versions, and that constitutes a significant difference. The same clustered index that was added to the new, partitioned version needs to be on the original before a comparison takes place. Having the same clustered index on the original will remove the key lookup on 40M records, the nested loop join, and the index scan, and the disparity will not be so exaggerated.
Superb
This is very helpful