Tuesday, April 08, 2008

Database maintenance routines

List of maintenance procedures.

Database maintenance routines

EDIT: Updated link to the new version of isp_ALTER_INDEX.

Over the past couple of weeks, I have posted various database maintenance stored procedures.  Here's a listing of them:

Do not put these in the master database.  An Admin database should be created where non-application specific objects are put.  All of the stored procedures are designed so that they do not need to be in any particular database.

Use them at your own risk.  If you don't use them, at the very least create your own.  Don't use the maintenance plan wizards or the sqlmaint utility!

Database maintenance routines

No comments: