为什么要从 SQL2000 升级到 SQL2005？
我正在寻找您对已经从 SQL2000 跃迁到 SQL2005 感到高兴的最大原因。
I'm looking for the single biggest reason you are glad that you've already made the jump from SQL2000 to SQL2005.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（15）
因为：
Because:
本地 XML 支持对我们来说非常重要。
Native XML support is big for us here.
SSIS 支持。 击败 DTS 并且非常方便。 :)
SSIS support. Blows DTS away and is quite handy. :)
SSRS - 对于我的组织来说，一个真正巨大的优势是拥有 SQL Server 2005 附带的免费报告工具。Reporting Services 使我能够在很短的时间内生成美观的报告，其中包含我们的经理所需的字段。 它有一个内置工具，因此可以将其转换为 Excel、PDF 或其他几种格式。 这里有很多价值。
SSIS - 2005 年的集成服务对于 ETL（导出、转换、加载）功能非常强大。 您可以设置自动化流程以按计划运行。
SSAS - 分析服务看起来很有前途。 我还没有制作任何数据立方体，因为我想组织一个实际的数据仓库。 一旦掌握了这些，就已经内置了强大的数据挖掘算法。
看看 SQL Server 2005 中包含的这三个工具。如果我必须选择一个工具作为迁移到 2005 年的最大原因，那就是 SSRS。
此时，我建议查看 SQL Server 2008。
SSRS - A really huge advantage for my organization is having the free reporting tools that come with SQL Server 2005. Reporting Services allows me to produce nice looking reports that have exactly the fields that our managers need in very little time. It has a built in tool so they can convert to excel, pdf, or several other formats. Lots of value here.
SSIS - Integration services in 2005 is very powerful for ETL (export, transform, load) functions. You can set up automated processes to run on a schedule.
SSAS - Analysis services looks promising. I have not made any data cubes yet because I want to organize an actual data warehouse. Once you have that, robust data mining algorithms are already built in.
Take a look at these three tools that are included with SQL Server 2005. If i had to pick one as the single biggest reason to move to 2005, it would be SSRS.
At this point, I would suggest looking at SQL Server 2008.
无需（手动）创建临时表的分页是一项基本但巨大的改进。
但是，如果您要拖动 & 直接从数据表中删除 ASP.NET 应用程序中的一些 GridView，您将在应用程序中进行分页...
Pagination without (manually) creating temporary tables is a basic, but huge improvement.
However, if you are then going to drag & drop some GridViews in your ASP.NET app directly from the data table, you'd be paging in the app...
CLR集成
CLR integration
基于行版本控制的事务隔离
Row Versioning-Based Transaction Isolation
我认为最大的原因是 Vista 不支持 SQL 2000。 因此我不得不转向 SQL 2005。
I think the single biggest reason is that SQL 2000 is not supported on Vista. I had to move to SQL 2005 because of that.
我不知道是否只有我这么认为，但 Linq2SQL 并不完全能够与 SQL 2000 完美配合。通常它应该根据架构的键、外键、RI 等进行推断来自动生成和填充子集合。在以下环境下工作得很好2005年，但2000年我运气不太好。
I don't know if it's just me, but Linq2SQL doesn't exactly work perfectly with SQL 2000. Ordinarily its supposed to automatically generate and populate child collections based on inferences from your schema's keys, foreign keys, RI, etc. Works fine in 2005 but i haven't had much luck in 2000.
事实证明，通用表表达式非常有用。
Common Table Expressions have proven incredibly useful.
异常处理...我们如何在 SQL 2000 上进行管理...？
Exception handling... how did we ever manage on SQL 2000...?
枢轴。 这个漂亮的小语句比任何其他 SQL Server 2005 增强功能节省了我更多的时间。
PIVOT. That beautiful little statement has saved me more time then any other SQL Server 2005 enhancement.
您无法再通过“右键单击”导出表格。 这与其说是一个好理由，不如说是一个问题。
YOU CAN'T EXPORT TABLES with a "right click" anymore. This is more of a problem than a good reason.
动态管理视图
用于优化并快速找出服务器的状态。
Dynamic Management Views
for Optimisation and to quickly find out the state of the server.