Why rebuild index when start sql? You can do that during off hours.
Printable View
Why rebuild index when start sql? You can do that during off hours.
The whole process is done during off hours. We do a server reboot, disk defrag, and index rebuilding at 2am every Sunday morning.
Your DBCC Shrink file job should executed after the DBCC reindex job.
Thanks for the advice. Next time I do a shrink I will turn off the reindex job. Then if the file doesn't grow, that will be a good indication that the reindexing was the cause of the file growth.