Authored by: Anonymous on Wednesday, December 26 2012 @ 10:02 am UTC

Glad I could be of service, sir.Here's what we do in ptiducroon:I use Michelle's dba_indexDefragStandard_sp from SQL Server Pedia to defrag all of the indexes on tables (due to our constant replication they need it on a nightly basis). Afterwards, I have a script that runs UPDATE STATISTICS WITH FULLSCAN on all tables. This sequence of events happens once a week.Every night we also have several massive load processes that truncate summary tables and rebuild them from the previous day's data. These get special attention with their own dba_indexDefragStandard_sp run and UPDATE STATISTICS WITH FULLSCAN.Even on our ptiducroon DB the full index reorg/rebuild and stats update only takes 44 minutes. Of course, as things grow we'll need to modify these behaviors, but for now it's working well

[ Reply to This | Parent | # ]