SQL CLUSTERED INDEX FYI

"if the clustered index is built online by using CREATE INDEX WITH DROP_EXISTING, ONLINE=ON, all associated nonclustered indexes are re-created online also."
ref: http://technet.microsoft.com/en-us/library/ms190981.aspx

I missed that and am now paying for it with current wait time of 4 hours and 30 minutes and counting on a 112 million record partitioned table.

Watching the progress with:
SELECT
*
FROM
sys.partitions
WHERE
OBJECT_ID = OBJECT_ID('claimreport')
AND ROWS > 0
Order by
Partition_NUMBER,Rows desc, index_id

Be sureto monitor your log growth.

Comments :

0 comments to “SQL CLUSTERED INDEX FYI”