SQL Server 2008 Table Maintenance - Rebuild, Reorganize, Update Stats, Check Integrity etc HELP!
Posted
by Albert
on Stack Overflow
See other posts from Stack Overflow
or by Albert
Published on 2010-03-31T20:00:14Z
Indexed on
2010/03/31
20:03 UTC
Read the original article
Hit count: 352
I'm migrating a ~15GB database from SQL Server 2005 to a new server running SQL Server 2008, and along with that I need to create all the new Maintenance Plans. I can take care of all the backup stuff, but the table maintenance baffles me some. Does anyone have any input on how often I should (or how often you do would suffice too) the following tasks?
- Check Database Integrity
- Rebuild Indexes
- Reorganize Indexes
- Update Statistics
- Shrink Database?
Am I missing anything? Again if you can share how often you do these tasks that would be great...and/or share any general information about your approach to table maintenance that would be helpful. Lastly does it matter what order I run these tasks in (when setting up a job)?
© Stack Overflow or respective owner