DB&的总大小SQL Server中的表 [英] Total Size of the DB & Table in SQL Server

问题描述

大家好，



任何人都可以告诉我我们可以在一个表格和数据库中存储多少数据。



（即）



单一数据库的总大小

AND

单个桌子的总大小



尺寸（MB或GB）





注意：我并不是指使用的尺寸......

i需要总容量（尺寸）可以单（DB和Table）存储数据。

hi all,

Can any one tell me how much of data we can store in a single table and in the database.

(i.e)

Total size of the SINGLE DATA BASE
AND
Total size of the SINGLE TABLE

Size in ( MB or GB )


Note: i didn't mean the used size...
i need the total capacity(size) can single (DB & Table) can store datas.

推荐答案

数据库的最大大小（32或64位）为524,272 。



I不要认为对表格大小有严格的限制，它会受到可用存储量和数据库上限的限制。行数显然决定了表格中的数据量，列为受可用存储空间限制。



请参阅此处以获取完整参考 SQL Server的最大容量规范 [ ^ ]



希望这有帮助，

Fredrik

Max size of a database (32 or 64 bit) is 524,272 TB.

I don't think there's a strict limit on table size, it will be capped by the amount of storage is available and the database cap of course. The number of rows, which would obviously dictate the amount of data in a table, is listed as "Limited by available storage".

See here for full reference; Maximum Capacity Specifications for SQL Server[^]

Hope this helps,
Fredrik

您可以查看链接 http://msdn.microsoft.com/en-us/library/ms143432.aspx [ ^ ]用于sql server db的容量相关查询

You can check the link http://msdn.microsoft.com/en-us/library/ms143432.aspx[^] for the capacity related queries for sql server db

这篇关于DB&的总大小SQL Server中的表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！