Pivoting data without an aggregation column

Don’t use PIVOT for non-aggregate-able data I ran into a rather displeasurable experience where a separate team of people built some very important tools for us and they did a lackluster job and...

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...

SQL Server rows appear to not be deleting

The Stupid Problem You are working on a database that you are not very familiar with as a developer – meaning that you are not going to think of every little thing that a DBA would think of righ...