SQL Server 2000 tables

Posted by user40766 on Server Fault See other posts from Server Fault or by user40766
Published on 2010-04-28T17:38:01Z Indexed on 2010/04/29 1:27 UTC
Read the original article Hit count: 657

Filed under:

sql-server

|

sql-server-2000

|

sql-server-2005

|

tables

|

large-data

We currently have an SQL Server 2000 database with one table containing data for multiple users. The data is keyed by memberid which is an integer field. The table has a clustered index on memberid.

The table is now about 200 million rows. Indexing and maintenance are becoming issues. We are debating splitting the table into one table per user model.

This would imply that we would end up with a very large number of tables potentially upto the 2,147,483,647, considering just positive values.

My questions:

Does anyone have any experience with a SQL Server (2000/2005) installation with millions of tables?
What are the implications of this architecture with regards to maintenance and access using Query Analyzer, Enterprise Manager etc.
What are the implications to having such a large number of indexes in a database instance.

All comments are appreciated.

Thanks

© Server Fault or respective owner

Related posts about sql-server

SQL SERVER – Beginning SQL Server: One Step at a Time – SQL Server Magazine

as seen on SQL Authority - Search for 'SQL Authority'
I am glad to announce that along with SQLAuthority.com, I will be blogging on the prominent site of SQL Server Magazine. My very first blog post there is already live; read here: Beginning SQL Server: One Step at a Time. My association with SQL Server Magazine has been quite long, I have written nearly… >>> More
How to install SQL Server 2005 Configuration Manager without installing SQL Server Management Studio

as seen on Server Fault - Search for 'Server Fault'
Hi, I need to configure SQL Server aliases on a public-facing production server. To do that, I need to install SQL Server Configuration Manager. I was not able to find a standalone installer for that, so I am having to install SQL Server 2005 Client Components. This approach is not ideal as we don't… >>> More
[MAJ] SQL Server 2005 Express Edition - La version gratuite de SQL Server 2005

as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
Modification technique pour le site de l'article. >>> More
How to create SQL Server Express DB from SQL Server DB

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a SQL Server 2008 DB. I want to extract SOME tables (and associated schema, constraints, indexes, etc) and create a SQL Server Express DB. It isn't a sync of the target, we stomp on it. We ONLY need to do this in the file system (not across the wire). We are not fond of the synchronization… >>> More
sql server 2000 error, error trying to connect to sql server 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
i am connecting to sql server 2000 on a remote computer with a dotnet application, but when i try to open the connection it gives the following error: When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections What… >>> More

Related posts about sql-server-2000

sql server 2000 error, error trying to connect to sql server 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
i am connecting to sql server 2000 on a remote computer with a dotnet application, but when i try to open the connection it gives the following error: When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections What… >>> More
SQLAuthority News – 2 Security Updates for SQL Server 2000 SP 4 Users

as seen on SQL Authority - Search for 'SQL Authority'
If you are using SQL Server 2000 still today my very first recommendation to you is to upgrade to SQL Server 2012. SQL Server 2000 is now 12 years old product and since then many new enhancements as well features which are relevant to current growth and progress in Informational Industry. Now is the… >>> More
Syncsort's Backup Express Supports SQL Server 2000 and DB2-UDB in SAP Solution Environments

as seen on Internet.com - Search for 'Internet.com'
A SQL Server 2000 and a DB2-UDB SAP Solution Environment Integration Assessment of Syncsort Incorporated's enterprise data backup and restore product, Backup Express, asserted that Backup Express provides high value to SAP customers. >>> More
SQL Server 2000 (8.0) SP 4 crash after load Linked Servers

as seen on Server Fault - Search for 'Server Fault'
Hello I configured one Oracle 10g Linked Server on my SQL Server 2000, so two days ago I can view the tables and views, today when I try to check it again I get an connection error, something with latency and time out operation "readsni" in the process of login the sa user. Then I lost all connections… >>> More
SQL Server 2000 incorrect message: duplicate key with unique index

as seen on Stack Overflow - Search for 'Stack Overflow'
Database server: SQL Server 2000 - 8.00.760 - SP3 - Standard Edition I have a table with 5 columns, in which I want to add a large (300.000) number of records. There is a unique index on the combination of two columns. If I add the records with this unique index in place, SQL Server gives this error… >>> More