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?