Tag Info

New answers tagged


I've done this a few times. My servers are only 2008R2, however. I've moved tables like this and 'partitioned' data both because data files were reaching the max size (16tb) and identity columns were reaching the integer maximum. Index rebuilds on big tables can take some time to roll back. Reorganization does not, however it is much slower (single ...


Cancelling an index build (be it online or offline) is a nearly instantaneous operation. The rollback work is very little. My guess is that some metadata changes must be rolled back and the in-build index pages must be deallocated. I just tested this on a database I had at hand. Should this procedure fail (even due to power loss) the index rebuild will be ...

Top 50 recent answers are included