"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.
Obscure Mobile Design Techniques That Boost UX
7 hours ago
Comments :
Post a Comment