Scott
Member since Jul 9, 2013
- Profile: /members/11052-scott.htm
- Comments: 2
Recent Blog Comments By Scott
-
Why NULL Values Should Not Be Used in a Database Unless Required
Posted on Sep 14, 2013 at 2:36 PM
@Scott DBA, Well, you should feel nostalgic if you were taught correctly. Broad sweeping normalization statement: yes; fueled by theoretical ideals: yes; absolutely always practical in every case: no. Nulls are simply a niggle of mine, not to say allowing them is so bad it's only that they are no... read more »
-
Why NULL Values Should Not Be Used in a Database Unless Required
Posted on Jul 9, 2013 at 12:28 PM
You are so spot on! NULLs have their place but NOT in tables--use defaults and/or force real values. Also, in most cases If something could possibly be NULL it should really be in another table. This is NOT an opinion....... read more »