It’s been a couple of weeks since my last post, but I swear I have a good excuse. I’ve been busily working on a separate writing project, but I’m back now and ready to continue rolling my own maintenance plan. To recap, so far I’ve covered backups, backup cleanup, and updating statistics. Today I’m going […]
A developer asked me today what the difference was between ALTER INDEX … REBUILD and ALTER INDEX … REORGANIZE. One of the scripts he was running was first doing a rebuild of all indexes on a table, then doing a reorg, and he wanted to know if the reorg was necessary. I took his question […]
I just couldn’t let it go. Right after my last post I decided I just wasn’t satisfied with that maintenance script. First of all, it only worked on one database at a time. And secondly, there were just too many selects within the cursor loop. And, personally, I’d rather work with a temp table than […]
As I’ve stated before, databases aren’t getting any smaller. Business and legal requirements are mandating that we gather and retain more and more data that, in the past, we might have purged from time to time. It’s a simple fact that database indexes must be maintained, statistics updated, and databases backed up; and the bigger […]
