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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy