I am running the following scripts to reindex my database tables
sp_MSforeachtable @command1="print '?' dbcc dbreindex ('?')"
sp_msforeachtable 'update statistics? with fullscan'
to update the stats.
During the execution of first script it hangs down my production server for about 1 hour.
Can anyone tell me any alternate for this so that my production sever does not stop responding during re indexing?
Thanks in advance.
View Complete Post