John W. Colby
jwcolby at colbyconsulting.com
Tue Jul 5 18:50:01 CDT 2005
Every database has limitations based on the number of bits used in tables to define the storage. It may be high, but it will exist. There will also be maximums inferable based on container size and data size. For example if the max container size is 2gb (personal version) and you want to store a single long (32 bit) value then you could store ~512 million records minus overhead. I am not finding published maximums for number of records. John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Francisco Tapia Sent: Tuesday, July 05, 2005 5:48 PM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] limit to records? not that I'm aware of., I think the only limitation is hdd size. On 7/5/05, Susan Harkins <ssharkins at bellsouth.net> wrote: > Is there a limit to the number of records a SQL Server table can > store? > -- -Francisco http://pcthis.blogspot.com |PC news with out the jargon! http://sqlthis.blogspot.com | Tsql and More... _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com