RYO Maintenance Plan – Index Maintenance
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 [...]
March 5, 2012
Tags: database maintenance, index maintenance, scripts, SQL Server Posted in: Maintenance 
No Comments
Index Maintenance: Rebuild vs Reorg
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 [...]
August 22, 2011
Tags: index maintenance Posted in: Maintenance 2 Comments
Maintenance 3.0
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 [...]
June 6, 2011
Tags: index maintenance Posted in: Maintenance No Comments
The ever-shrinking maintenance window
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 [...]
June 2, 2011
Tags: index maintenance, update statistics Posted in: Maintenance No Comments
