Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
 Posted - 2007-10-24 : 19:55:54
|
| I am designing the database.I was told to create a table with nearly 120 fields..and another two tables with 35 fields and 50 fields.the data was stored to 100,000 (aproxmately) per year.Please suggests will it be a problem if the table contains 120 columns. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-24 : 20:16:42
|
| Why do you need 120 columns? If you are the designer, then you should be making the design decisions, not someone else. Will the database be properly normalized?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
LoztInSpace
Aged Yak Warrior
940 Posts |
Posted - 2007-10-24 : 22:23:06
|
| "Will the database be properly normalized?" That's the question. There is nothing inherently wrong with 120 columns. The number of columns is a function of the requirements and the resulting normalised data model. If it's right it's right. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-25 : 11:59:00
|
| Personally I'd break up a table that had 120 columns even if it was already normalized. I'd put the least frequently accessed/updated columns into their own table.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
LoztInSpace
Aged Yak Warrior
940 Posts |
Posted - 2007-10-25 : 19:58:18
|
quote:
Originally posted by tkizer
Personally I'd break up a table that had 120 columns even if it was already normalized. I'd put the least frequently accessed/updated columns into their own table.
Why? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-25 : 20:04:42
|
| Because this is what you do with tables with lots of columns. I believe the recommendation has to do with the clustered index and maintenance on it. I don't have articles at-hand that describe this, otherwise I'd provide them here. I'm just going by memory.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Database design help