Maximum number of tables?

What is the maximum number of tables that SQL Server 2000 can cope with?Joe wrote:
> What is the maximum number of tables that SQL Server 2000 can cope with?
No specification for tables only, but it can contain 2,147,483,647
objects overall.|||From BOL:
"Database objects include all tables, views, stored procedures, extended
stored procedures, triggers, rules, defaults, and constraints. The sum of
the number of all these objects in a database cannot exceed 2,147,483,647."
... But you said, "cope with". That's a different question. The question
isn't how many tables--but what you're doing with those tables. I can bring
a big server to its knees with a single large, very badly designed table.
So coping is not about number of objects, but how they're used.
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"Joe" <joe@.hotmail.com> wrote in message
news:%23cEOzRcoFHA.3960@.TK2MSFTNGP12.phx.gbl...
> What is the maximum number of tables that SQL Server 2000 can cope with?
>

Maximum number of tables?

What is the maximum number of tables that SQL Server 2000 can cope with?
Joe wrote:
> What is the maximum number of tables that SQL Server 2000 can cope with?
No specification for tables only, but it can contain 2,147,483,647
objects overall.
|||From BOL:
"Database objects include all tables, views, stored procedures, extended
stored procedures, triggers, rules, defaults, and constraints. The sum of
the number of all these objects in a database cannot exceed 2,147,483,647."
... But you said, "cope with". That's a different question. The question
isn't how many tables--but what you're doing with those tables. I can bring
a big server to its knees with a single large, very badly designed table.
So coping is not about number of objects, but how they're used.
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
"Joe" <joe@.hotmail.com> wrote in message
news:%23cEOzRcoFHA.3960@.TK2MSFTNGP12.phx.gbl...
> What is the maximum number of tables that SQL Server 2000 can cope with?
>

Maximum number of tables?

What is the maximum number of tables that SQL Server 2000 can cope with?Joe wrote:
> What is the maximum number of tables that SQL Server 2000 can cope with?
No specification for tables only, but it can contain 2,147,483,647
objects overall.|||From BOL:
"Database objects include all tables, views, stored procedures, extended
stored procedures, triggers, rules, defaults, and constraints. The sum of
the number of all these objects in a database cannot exceed 2,147,483,647."
... But you said, "cope with". That's a different question. The question
isn't how many tables--but what you're doing with those tables. I can bring
a big server to its knees with a single large, very badly designed table.
So coping is not about number of objects, but how they're used.
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"Joe" <joe@.hotmail.com> wrote in message
news:%23cEOzRcoFHA.3960@.TK2MSFTNGP12.phx.gbl...
> What is the maximum number of tables that SQL Server 2000 can cope with?
>

Maximum number of tables?

What is the maximum number of tables that SQL Server 2000 can cope with?Joe wrote:
> What is the maximum number of tables that SQL Server 2000 can cope with?
No specification for tables only, but it can contain 2,147,483,647
objects overall.|||From BOL:
"Database objects include all tables, views, stored procedures, extended
stored procedures, triggers, rules, defaults, and constraints. The sum of
the number of all these objects in a database cannot exceed 2,147,483,647."
... But you said, "cope with". That's a different question. The question
isn't how many tables--but what you're doing with those tables. I can bring
a big server to its knees with a single large, very badly designed table.
So coping is not about number of objects, but how they're used.
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"Joe" <joe@.hotmail.com> wrote in message
news:%23cEOzRcoFHA.3960@.TK2MSFTNGP12.phx.gbl...
> What is the maximum number of tables that SQL Server 2000 can cope with?
>