Top Tips for Effective SQL Server Database Maintenance

Archived post from 2011. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.

SQL Server MVP and all around SQL guru Paul Randal looks at his Top Tips for Effective SQL Server Database Maintenance in a new TechNet article. This isn’t targeted at the absolute beginner DBA but is appropriate for involuntary DBA’s trying to improve their skills.

Original article: https://technet.microsoft.com/en-us/magazine/2008.08.database.aspx