Scenario As usual when you don’t do something for a very long time, it is easy to forget what you knew already. I had to […]
Small date time is garbage and you should stop using it
Smalldatetime has been obsolete for a long time now get with the program A major pet peeve of mine is the smalldatetime datatype from SQL […]
Padding a string in tSQL
Gotcha There isn’t a Pad Left or Pad Right function in tSQL. Solution There is a lengthy discussion about this topic already on Stack Overflow […]