Opinion: Which SQL Server columns should be nullable part 2: Avoid placeholder values
In my previous opinion post, I was discussing why magic values where a problem. They are often added by developers when they are trying to avoid having any NULL data in a database.
While discussing this, I think it’s worth also highlighting the overall dangers of placeholder values. These are values that aren’t magic values but are ones that are intended to be replaced at a later time.
If you use any of these, you need to have a solid process in place to:
2018-04-17