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 [...]
Posts Tagged ‘Maintenance’
“Smart” Reindexing (SQL Server 2005, 2008)
Something that still baffles me about SQL Server is that even in SQL Server 2008 there is no maintenance plan option to do reindexing properly. The key word in that sentence is properly. SQL Server gives you an all or nothing approach to indexing. You have 2 options: 1) Rebuild Indexes 2) Reorganize Indexes (Great [...]
