MSSQL – How to use Table Partitioning for Big Data Tutorial

Link to Scripts in Demo –
Link to Adventure Works DB –

Tutorial of the Microsoft SQL Server Table Partitioning Step by Step Explained


  1. 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.

Leave a Reply

© 2023 53GB