Re: better - One large Tbl or 4 sub Tbls?
This is a discussion on Re: better - One large Tbl or 4 sub Tbls? within the SQL Server forums, part of the Microsoft SQL Server category; --> Splitting a table up into 24 tables with all the same fields is one thing. My deal was that ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 05:55 PM
| ||||
| ||||
 Re: better - One large Tbl or 4 sub Tbls? Splitting a table up into 24 tables with all the same fields is one thing. My deal was that we have a table with 200+ fields and they were splitting the table up where we had 4 tables with all different fields. Each time we had to query a row for something we had to join 4 tables. It just didn't seem right. Rich *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!      |
Linear Mode
