What is a better design principle when designing SQL Server tables.
One can either add columns (ie grow horizontally) or grow it vertically (ie rather adding rows)
I have a situation when there are normally a number of items, say 2- 12 that are generally related to one another.
Just to keep it simple, they would have the same values in 4 of their columns but 3 would be different.
Would it be better to now add the 12 entries in their own row, or would it be better to say add additional columns that would help me combine all the entries into one row, but be able to identify which one was which.
I dont think I have explained the situation well enough to get a specific answer relating to my situation.
But I am asking in general which is better practice?
Best Answer
The extreme example of the vertical design pattern is called entity-attribute-value. Generally speaking, you don't want to use the EAV design pattern with SQL Server due to challenges with indexing and constant joins.
To find the right middle ground, review Joe Celko's post on normalization in SQL Server Central's Stairways series. Note the sections on 3rd normal form.