Rotating Header Image

Posts from ‘July, 2009’

SQL Bacon Nugget of Excellence Award @SQLAgentMan

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 […]

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: 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 & 0x40) <> 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 […]

Twitter links powered by Tweet This v1.6.1, a WordPress plugin for Twitter.