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