database tables

[Anti-Rich]

hi all,

just wondering how many tables sql server can handle (and rows per table) before the database starts getting overly cluttered and slow to respond.

what are ways of getting around problems of too many tables?

cheers for anyone's input

regards
adam

EDIT: im using sql server 2005 express, btw, not sure if this affects anything.

 

[vis781]

The Maximum size a SQL server Database can reach is:-

1,048,516 terabytes

The Maximum number of database instances per instance of SQL server:-

32,767

The Maximum number of tables per database is only limited by the number of objects in a database.

The Maximum number of rows a table can hold is only limited by the available storage space.

 

[Anti-Rich]

holy crap thats insane!

but do you know at what point it starts to slow the server/database access down?

cheers

adam

 

[vis781]

I've never heard of a definitive size that wil start to affect the performance of SQL server. You are more likely to see performance hits from the application than the server its self. Saying that though, it is important to not include more than 253 foreign key constraints as this is the recommended maximum, specifying additional foreign key constraints may be expensive for the query optimizer to process. Other than that, i know of no known performance issues with SQL server, it is quite a fantastic piece of kit.

 

[Anti-Rich]

oh ok, cheers for the advice, much appreciated!

regards
adam