We have database with high transaction rate. I am creating a maintainance plan and wondering how often should I update statistics, reorganize index, rebuild index.
I am thinking,
1. Update statistics and reorganize index every day after hours when there is not much activity on the DB
2. Rebuild index every weekend.
3. Also do I need to incude systems databases in the daily diffrential backups
Any suggestions please.
View Complete Post