Biases in naming database objects

Introduction Over my whole software engineering career, I have watched and learned the right way and the wrong way to style and format code. Especially when it comes to naming objects. There has been ...

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