[dba-SQLServer] limit to records?

Susan Harkins ssharkins at bellsouth.net
Tue Jul 5 19:40:37 CDT 2005


 Thanks John -- thanks everyone -- it's been an interesting discussion. 

Susan H. 

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.





More information about the dba-SQLServer mailing list