Maximum data can be store per table?

• Louis_See1

  Ten Centuries

  Points: 1100

  More actions

  January 17, 2003 at 2:02 am

  #75992

  Anyone can tell me what is the maximum size data can be store per table?

  Thanks in advance..

• Antares686

  SSC Guru

  Points: 125444

  More actions

  January 17, 2003 at 4:45 am

  #446606

  Number of rows and data size is not limited for table. Only width of rows which is delved into a bit here.

  http://www.sqlservercentral.com/columnists/sjones/pagesize.asp

  A table go go well into terrabytes. However, if you use and identity column you are limited to the range of the datatype

  tinyint 0 through 255 so 256 total rows limitation with that datatype

  smallint -32,768 through 32,767 or 65536 total rows possible

  int -2,147,483,648 through 2,147,483,647 or 4,294,967,296 total possible rows

  and then of course bigint with 2000 which is a lot more

  So the key is how your data may limit itself.

  Now if you were talking about width it can vary based on number of columns and type (varible or fixed width). But 8k is the maximum row width.