Microsoft SQL Server: Essential Database Maintenance
Play Microsoft SQL Server: Essential Database Maintenance
In this session, Paul and Kimberly run you through their top-ten database maintenance recommendations, with a lot of tips and tricks along the way. These are distilled from almost 30 years combined experience working with SQL Server customers and are geared towards making your databases more performant, more available, and more easily managed (to save you time!). Everything in this session is practical and applicable to a wide variety of databases. Topics covered and myths debunked include: backups, shrinks, fragmentation, statistics, and much more! Focus is on 2005 but we explain some of the key differences for 2000 and 2008 as well.