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-06-01 : 23:20:24
|
| I have design a db which contains only 1 tables with 280 columns.I want to make more tables with a relationship since my superior wants the data to be stored in a single table.Basically the data is coming from flat files,which it will be stored in a single table.I want to know what type of potential issues will be expected if we use 280 columns table.. |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-06-02 : 01:50:53
|
are all 280 columns really attributes of a single entity? seems unlikely.more likely is that several entities are represented in each row of your 280 column flat file. if that's the case, you ought to have one table for each such entity, with foreign keys between related entities.
www.elsasoft.org |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Db desing sqlserver 2000