http://blogs.msdn.com/b/sqlqueryprocessing/archive/2007/05/08/index-build-strategy-in-sql-server-part-4-1-offline-serial-parallel-partitioning-non-aligned-partitioned-parallel-index-build.aspxRecall 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 whenen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.msdn.com/b/sqlqueryprocessing/archive/2007/05/08/index-build-strategy-in-sql-server-part-4-1-offline-serial-parallel-partitioning-non-aligned-partitioned-parallel-index-build.aspx#10376408Tue, 11 Dec 2012 09:45:14 GMT91d46819-8472-40ad-a661-2c78acb4018c:10376408Satheesh Variath<p>awesome....</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10376408" width="1" height="1">http://blogs.msdn.com/b/sqlqueryprocessing/archive/2007/05/08/index-build-strategy-in-sql-server-part-4-1-offline-serial-parallel-partitioning-non-aligned-partitioned-parallel-index-build.aspx#8412590Sun, 20 Apr 2008 21:44:56 GMT91d46819-8472-40ad-a661-2c78acb4018c:8412590Options Trading &raquo; Index Build strategy in SQL Server - Part 4-1: Offline Serial/Parallel Partitioning (Non-aligned partitioned index build)<p>PingBack from <a rel="nofollow" target="_new" href="http://stocks-options-trading.info/options-trading/?p=981">http://stocks-options-trading.info/options-trading/?p=981</a></p> <img src="http://blogs.msdn.com/aggbug.aspx?PostID=8412590" width="1" height="1">