Welcome to MSDN Blogs Sign in | Join | Help

May 2007 - Posts

Sunday, May 13, 2007 9:15 PM

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

Source Partitioned While the table is partitioned, we may want to change the way it is partitioned when building the new index. For example, by using the same partition function and scheme, the new index can be partitioned on different columns than the
Posted by queryproc | 1 Comments
Filed under:
Tuesday, May 08, 2007 11:56 AM

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

Recall that in the previous posts on index build, we defined "aligned" as the case when base object and in-build index use the same partition schema, and "non-aligned" to be the case when heap and index use different partition schemes, or the case when
Posted by queryproc | 1 Comments
Filed under:
 
Page view tracker