-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|