Arthur Fuller
artful at rogers.com
Wed Jul 6 17:31:29 CDT 2005
I've read the docs too, and agree that what you say corresponds with what MS says. But I lack the hardware resources to test this effectively. Does anyone on this list have sufficient HW resources to create a multi-TB database and then to test its response time? I doubt it but I thought I would ask anyway. A. -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: July 5, 2005 6:27 PM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] limit to records? On 5 Jul 2005 at 17:13, Susan Harkins wrote: > Is there a limit to the number of records a SQL Server table can store? > BOL: SQL Server 2000 has high-speed optimizations that support very large database environments. SQL Server version 6.5 and earlier can support databases from 200 GB through 300 GB. SQL Server 2000 and SQL Server version 7.0 can effectively support terabyte-sized databases -- Stuart _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com