SQL Server 2005 Express 中的表限制
我在 SQL Server 2005 Express 中有一个数据库表，每天接收 2367 个新行，每行只有 3 列。因此，一年内将产生大约 80 万行，十年后将产生 800 万行。因为我知道我进行此安装的公司不会处理任何数据库管理/清理，所以我的问题是 SQL Server 2005 Express 是否能够处理单个表中的这么多行？有限制吗？我确实知道文件大小有 4gig 之类的限制。
编辑：表设置
[RefId] [bigint] NOT NULL,
[PointDate] [datetime] NOT NULL,
[PointValue] [decimal](10, 2) NOT NULL
注意：SQL Server 2005 Express 不允许您设置作业。
I have a database table in SQL Server 2005 Express that takes in 2367 new rows each day, there is only 3 columns for each row. So in a year this will give around 800k of rows and in 10 years 8 million rows. Since I know that the company where I'm making this installation will not handle any database management/cleanup my question is will a SQL Server 2005 Express be able to handle this many rows in a single table? Are there any limits? I do know that there is something like 4gig of file size limit.
EDIT: Table setup
[RefId] [bigint] NOT NULL,
[PointDate] [datetime] NOT NULL,
[PointValue] [decimal](10, 2) NOT NULL
note: SQL Server 2005 Express doesn't allow you to set up jobs.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
数据库大小限制为 10Gb从 SQL Server 2008 R2 开始。无论如何，快速安装仍然需要维护（特别是备份）。你现在最好想点办法。
The database size limit is 10Gb since SQL Server 2008 R2. No matter what, an Express installation will still require maintenance (specially backups). You better think of something now.
文档说受到可用存储的限制。因此，您很可能会首先在其他地方遇到瓶颈，例如某些使用 Access 的 MBA 使用指向实时数据库的外部链接执行 select Count() from Table 。
您可能首先遇到的其他最大值。
MSDN SQL 2005 容量规范
其他版本也可以从页面上获取，供有需要的人使用。
The documentation says limited by available storage. So it's likely you'll hit a bottleneck somewhere else first, like some MBA with Access doing select Count() from Table on with an external link to the live database.
Other maximums you might run into first.
MSDN SQL 2005 Capacity Specicifications
Other versions are available from the page as well, for those who have a need.