Enlarging a CHAR column

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 increase the column size of a CHAR field from 9 to 15 bytes and I totally...

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 server. Not because it exists or it was what was available at ...

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 here: https://stackoverflow.com/questions/16760900...