Top Tips for Effective Database Maintenance

Many of you new SQL Server DBAs may be wondering what are the things to lookout for to effectively maintain a production SQL Server database.

Paul Randal has written an excellent article on this very topic, and it covers the following points:

  • Managing data and transaction log files
  • Eliminating index fragmentation
  • Ensuring accurate, up-to-date statistics
  • Detecting corrupted database pages
  • Establishing an effective backup strategy