Index Build strategy in SQL Server – Part 3: Offline Serial/Parallel Partitioning

(Lyudmila Fokina) There are two main categories of partitioned index build: –Aligned (when base object and in-build index use the same partition schema) –Not- Aligned (when heap and index use different partition schemas (including the case when base object is not partitioned at all and in-bui

Read More - Register for Free Membership