Before you run reorg rebuild on a table:
Set the database option select into/bulkcopy/pllsort to true and run checkpoint in the database.
Make sure that additional disk space, equal to the size of the table and its indexes, is available.
To set select into/bulkcopy/pllsort to true and checkpoint the database, use the following isql commands:
1> use master 2> go 1> sp_dboption pubs2, "select into/bulkcopy/pllsort", true 2> go 1> checkpoint pubs2 2> go
Following a rebuild on a table:
You must dump the database containing the table before you can dump the transaction log.
Distribution statistics for the table are updated.
All stored procedures that reference the table will be recompiled the next time they are run.
