为什么要从SQL2000升级到SQL2005？

I'm looking for the single biggest reason you are glad that you've already made the jump from SQL2000 to SQL2005.

我正在寻找你已经从SQL2000跳到SQL2005的最大原因。

15 个解决方案

#1

Recursion without creating temporary tables.

递归而不创建临时表。

Native Exception support (Try/Catch instead of if @Error goto)

本机异常支持(尝试/捕获而不是@Error goto)

#2

Because:

Microsoft would like to remind customers that support for SQL Server 2000 Service Pack 3a (SP3a) will end on July 10, 2007.

Microsoft希望提醒客户,对SQL Server 2000 Service Pack 3a(SP3a)的支持将于2007年7月10日结束。

#3

Native XML support is big for us here.

本机XML支持对我们来说很重要。

#4

SSIS support. Blows DTS away and is quite handy. :)

SSIS支持。吹掉DTS,非常方便。 :)

#5

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.

SSRS - 我的组织真正的巨大优势是拥有SQL Server 2005附带的免费报告工具.Reporting Services使我能够生成外观漂亮的报告,这些报告具有我们的经理在很短的时间内所需的字段。它有一个内置工具,因此可以转换为excel,pdf或其他几种格式。这里有很多价值。
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.

SSIS - 2005年的集成服务对于ETL(导出,转换,加载)功能非常强大。您可以设置自动化流程以按计划运行。
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.

SSAS - 分析服务看起来很有前景。我还没有制作任何数据立方体,因为我想组织一个实际的数据仓库。完成后,内置了强大的数据挖掘算法。

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.

看一下SQL Server 2005附带的这三个工具。如果我必须选择一个作为移动到2005年的最大原因,它将是SSRS。

At this point, I would suggest looking at SQL Server 2008.

此时,我建议查看SQL Server 2008。

#6

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...

但是,如果您要直接从数据表中拖放ASP.NET应用程序中的某些GridView,那么您将在应用程序中进行分页...

#7

CLR integration

#8

Row Versioning-Based Transaction Isolation

基于行版本控制的事务隔离

#9

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.

我认为最大的原因是Vista不支持SQL 2000。因此,我不得不转向SQL 2005。

#10

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.

我不知道它是否只是我,但Linq2SQL与SQL 2000并不完全一致。通常它应该根据你的架构的密钥,外键,RI等的推断自动生成和填充子集合。工作正常2005年但我在2000年没有太多运气。

#11

Common Table Expressions have proven incredibly useful.

通用表格表达式已被证明非常有用。

#12

Exception handling... how did we ever manage on SQL 2000...?

异常处理......我们是如何管理SQL 2000的?

#13

PIVOT. That beautiful little statement has saved me more time then any other SQL Server 2005 enhancement.

枢。这个漂亮的小语句比其他任何SQL Server 2005增强节省了更多时间。

#14

YOU CAN'T EXPORT TABLES with a "right click" anymore. This is more of a problem than a good reason.

您无法再通过“右键单击”导出表格。这不是一个问题,而是一个很好的理由。

#15

Dynamic Management Views for Optimisation and to quickly find out the state of the server.

动态管理视图优化并快速找出服务器的状态。

#1

Recursion without creating temporary tables.