Posts Tagged ‘bloat’

So how do you drop databases? Do you use a simple DROP DATABASE statement? Do you detach the database and remove the files manually? Do you use the GUI? Run these two quick and dirty queries for me: SELECT COUNT(*) FROM   msdb.dbo.backupset SELECT COUNT(*) FROM   msdb.dbo.backupset WHERE  database_name NOT IN (SELECT name FROM master.dbo.sysdatabases)   So how much of your MSDB database is filled with backup [...]