• If you want to reclaim or rather not double your allocation for the rebuild then drop and then create your indexes. Or, Disable the nonclustered index and then rebuild.

    http://msdn.microsoft.com/en-us/library/ms179542(v=sql.105).aspx

    or google DROP CREATE vs. REBUILD for more explanation.

    Cheers,

    John M Dennis