July 3, 2002 at 1:25 pm
Browsing for how to properly detach/attach databases, I’ve found this comment:
"In general I think if you have more than 16 files you have too many anyway,..."
(http://www.sqlservercentral.com/columnists/awarren/attachanddetachagain.asp)
I’ve looked for other references about the number of tables in a database and found not much.
Since we’re going to migrate an 160+ tables database into MS-SQL, I’m quite interested to know why I shouldn’t have more than 16 tables in a db.
I’d appreciate any comments or suggestion where I can find more about the subject.
Thanks
João Alberto
July 3, 2002 at 2:24 pm
Files != Tables.
Files as in the files for the underlying physical structure of the database (see CREATE DATABASE). For instance, it is entirely possible to have 1 data file and 1 log file and have 500 tables.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
July 3, 2002 at 2:42 pm
OOPS - sorry for the misreading.
Topic closed!
Thanks
João Alberto (the MF)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply