Viewing 2 posts - 1 through 2 (of 2 total)
Hi,
Not sure if you have a requirement for the system to be online or if there an opportunity in the evening to run maintenance...
RE- EXEC sp_MSforeachtable @command1="print '?'", @command2="ALTER INDEX...
February 15, 2012 at 3:27 pm
#1447587
Try and increase your free space to be more than 20% and try again.
In regards to fragmentation also try and run CONTIG.
http://technet.microsoft.com/en-us/sysinternals/bb897428
Contig is a single-file defragmenter that attempts...
February 15, 2012 at 2:09 pm
#1447547