MS SQL Server 2000 tables
- by klork
We currently have an MS 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…