asked on

How many tables/indexes can be created in a database

Hi all

I am new to database, right now i am learning sql server 2000. My question is;

The book I am reading says the following regarding a database in SQL server 2000

Minimum size of default database = 1MB

Data is stored in a page of 8KB, ie database can store 128 pages in 1 MB, and these pages are generated when we create the database, with each page containing a header and '0' written to all bytes.

it goes on and explain that when a table/index is created, it creates "extents", extents are 64kb in size ie; 8 pages.

Now my qn is

Since these pages and extents are created at the time we create database and table, with all these DEFAULT conditions we can create only 128/8 ie 16 tables/indexes in a database.

Is it correct.Can any one comment on this?

Thanks

ASKER CERTIFIED SOLUTION

Brendt Hess

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

nigelrivett

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

rdrunner

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

CleanupPing

oc-C-gen:
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
EXPERTS:
Post your closing recommendations! No comment means you don't care.