Top Tips for Effective [SQL Server] Database Maintenance

“Several times a week I’m asked for advice on how to effectively maintain a production [SQL Server] database. Sometimes the questions come from DBAs who are implementing new solutions and want help fine-tuning maintenance practices to fit their new databases’ characteristics. More frequently, however, the questions come from people who are not professional DBAs but for one reason or another have been given ownership of and responsibility for a [SQL Server] database. I like to call this role the “involuntary DBA.” The focus of this article is to provide a primer of database maintenance best-practices for all the involuntary DBAs out there.”

Top Tips for Effective Database Maintenance

Note: I added [SQL Server] as appropriate.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>