delizat (8/10/2015)
Lynn Pettis (8/7/2015)
delizat (8/7/2015)
Every situation is different, but this is the order of my backup jobs:1. Reorganize/Rebuild index
2. Check integrity
3. Update Statistics
4. Backup database.
Please tell me you aren't updating statistics on indexes that you rebuilt.
Just a sarcastic comment and no constructive information? Every situation is different and there are no simple answers.
The post just prior shows the simple reorganize/rebuild maint step. It looks at fragmentation and decides to reorganize, rebuild, or do nothing. Depending on what it decides statistics will be run.
Here's a link from Paul S. Randal:
Not a sarcastic comment at all. A valid statement/question of concern.
I have seen DBAs that have rebuilt indexes and followed that with updating statistics using a 20% sample rate. Waste of time considering that the statistics on the indexes that were rebuilt were updated with a 100% sample rate while the index was rebuilt.