Index Build strategy in SQL Server – Part 4-2: Offline Serial/Parallel Partitioning (Non-aligned partitioned index build)

A source partitioned table can be mis-aligned to the index partition in many different ways. For example, by using the same partition function and scheme, we can have non-aligned case like the following where the table and the index are partitioned on different columns.

Read More - Register for Free Membership