So this is not going to be a daily, weekly, or monthly thing but every now and then I come across something that just deserves to get a *BUMP* back to the top of the RSS feeds out there. If you’re wondering how the whole “bacon nugget of excellence” name came about…I Tweeted this about [...]
Posts from ‘July, 2009’
Bloated MSDB database
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 [...]
EDMPASS – July Meeting
In July the Edmonton Chapter of PASS is going to have it’s 2nd meeting. Details below: http://www.eventbrite.com/event/378687665 Please be sure to not only click the “Add to my calendar” but also the “Register” button so that we can plan accordingly for food and drinks. Date: July 29th 2009 Time: 5:00 pm – 7:00 pm Location: Stanley A. Milner library [...]
Another Reason SQL 2000 should just go away! :)
Quick without looking it up… what does this script do: SELECT * FROM dbo.sysfiles WHERE (status & 0×40) <> 0 So if you’re like me and don’t have all the bit compares memorized for all the tables you probably didn’t know that this is how (in SQL 2000) you would query the current database to find all the transaction log files. Every now and [...]
