Re: Eliminating Nulls
Date: 1 Jul 2005 07:16:52 -0700
Splitting the row into two tables where all the attributes are related to a single entity is a violation of the rules of normalization. It is also inefficient. In the real word you do not always have or know a specific data item. Nulls are not difficult to deal with though SQL Server does vary from the ANSI standard in a couple of situations.