This is possibly the best blog I have every read on the subject of reviewing a database. It is witty, insightful, and mentions a number of very common problems. The descriptions of each problem are well written and easy to understand. There are multiple scripts and links throughout the post to help with both database maintenance and general review/troubleshooting.
Best of all it’s a quick read (if you don’t spend time carefully reading each script) and keeps your interest from start to finish. In short I HIGHLY recommend taking a few minutes and reading Brad Shultz’s “Shrink Your Databases Regularly”.
Filed under: Backups, Microsoft SQL Server, Performance, Problem Resolution, SQLServerPedia Syndication Tagged: backups, DMV, Performance, problem resolution