I didn't discover this, a person on StackOverflow did. Just read the question and did some thinking. If you are interested, then please read the question and potentially comment @ StackOverflow.
Read more →
FYI, if you are attending 2008 Pass, and are on your own dime or saving your employer money, it may be possible to get rooms at the La Quinta right next to the convention center right at $100.
Read more →
I use this function for testing. It takes in milliseconds and spits out the whole number value in various other rulers (seconds, minutes, etc).
USE MaasSql GO USE [MaasSql] GO /****** Object: UserDefinedFunction [cCode].
Read more →
My preferred method of persisting a DTS package is by saving it to the server and backing up MSDB. At one of my employers, I found many filepaths and other should be variables hardcoded in.
Read more →
Not much more to say other than, taking the resources - CPU, Memory, Time to loop through the characters in a phone number and retrieving all #’s is better than crap.
Read more →
It’s been a while since I used DTS. I was trying to remember the right way to do logging in DTS. First, I just said - hey, I’ll do a File System Object File.
Read more →
I really dug this explanation of the “slowness” in Management Studio. http://blogs.msdn.com/euanga/archive/2006/07/11/662053.aspx
This is the “official” kb article:
http://support.microsoft.com/kb/555686
Read more →
I am of the opinion that every table should have a clustered index. Also, I recently saw somewhere ( maybe SqlTeam, I don't remember ) a quote from Joe Celko, "You don't have a table unless you have a key.
Read more →
Synopsis: Views are evil, bad, buggy, temperamental, tortuous, and should be avoided.
Years ago, when I started out as a wee developer graduating from Microsoft Access, I tried and did port my favorite functionality of Access to Sql Server 2000.
Read more →
My momma always told me to share. Thankfully, sharing isn't always a two way street. Thankfully, because, I've never been great at it. I used to feel guilty every time I used the Internet to solve a problem at work.
Read more →