Thursday, 9 December 2010

Using MAXDOP to throttle an index build

CREATE UNIQUE CLUSTERED INDEX CI_MyIndex
ON Processiing.myPartitionedTable (DateTime, ID) WITH (MAXDOP=1,DATA_COMPRESSION = PAGE,ONLINE = ON)
ON PScheme_YearDateRange (DateTime) 
GO

Links :

MAXDOP WITH ALTER INDEX
http://www.sqldev.org/sql-server-database-engine/how-does-maxdop-work-with-alter-index-87328.shtml

MAXDOP
http://blogs.msdn.com/arali/archive/2009/11/26/sql-server-max-degree-of-parallelism-maxdop.aspx

Partitioning walkthrough
http://blog.sqlauthority.com/2008/01/25/sql-server-2005-database-table-partitioning-tutorial-how-to-horizontal-partition-database-table/

No comments: