So I get an email this morning from The President (no… not Obama but I sure would love to hear some “yes we can”…. as in yes we can fix your problem) Our Office of the President has responded to your request, details of which are described below: Our administrators have been extensively reviewing your [...]
Posts from ‘March, 2009’
My take on “The Challenge”
So last night I finally got some time to take a look at Adam Machanic’s T-SQL Challenge. Now obviously I wont/can’t post my solution cause it would both break the rules and well I’m not quite done yet LOL. I was very proud of myself the first couple times I “solved” the problem until I [...]
GROUPING SETS in SQL Server 2008
Have you ever wanted to merge together multiple group by statements into a single query? Me neither…. but let's say you got curious as to how you'd go about doing something like that. In SQL Server 2008 an enhancement/addition to the GROUP BY clause is the ability to group by multiple sets in 1 query. [...]
Please don’t install system databases on the C:\ Drive
OK so this sounds like one of those “well duh” type of posts (or maybe not) but it’s amazing how often I still find SQL Server installations with the system databases on the system drive. Some reasons why you should move your system databases off your C:\ (system) drive: Usually base configuration of system drives [...]
GoDaddy showing some love…
No they didn’t send over Danica Patrick or Candice Michelle to keep me entertained until we find the resolution to the comment notification problem over on EDMPASS.com… but I did get a call from the office of the president A friendly guy gave me a buzz and gave me a run down of what [...]