WEB开发网
开发学院数据库MSSQL Server SQL Server 2008是否是SQL Server 2005的一个补丁... 阅读

SQL Server 2008是否是SQL Server 2005的一个补丁包

 2008-09-02 09:58:15 来源:WEB开发网   
核心提示:随着SQL Server 2008越来越多地进入到大家的视线中,也有越来越多的声音说SQL Server 2008 (Kaitmai)仅仅是SQL Server 2005的一个补丁包,SQL Server 2008是否是SQL Server 2005的一个补丁包,当初我也是这个想法,因为我们把太多的目光放到了例如Geo

随着SQL Server 2008越来越多地进入到大家的视线中,也有越来越多的声音说SQL Server 2008 (Kaitmai)仅仅是SQL Server 2005的一个补丁包。当初我也是这个想法,因为我们把太多的目光放到了例如Geo-Spatial支持、Hierarchical ID、File Stream上,确实这些功能都是建立在SQL Server 2005搭建的CLR -Integrated平台上的,但是我们也需要看到SQL Server 2008中的其他功能,例如Resource Governor、Declarative Management Framework、Change Data Capture、Reporting Service IIS agnostic report deployment等等。SteveB在美国Launch中更将Policy-base Management列在SQL Server 2008 Top 10新功能的首位,还有美国Launch上关于Activity Monitor的改进、Object Search以及T-SQL Debugger被用户爱称为三项Surprise Features。当然还是会有人说这些都是在DMV和DDL Triggers的技术基础或技术路线上发展起来的,不过哪个产品不是从一条技术路线或某项基础性改革上发展起来的呢?

因此微软把SQL Server 6.0/6.5称为第一代数据库产品,SQL Server 7.0/2000称为第二代数据库,而SQL Server 2005/2008称为第三代数据库产品。以此类推,那么SQL Server vNext是不是会变成第四代数据库产品呢,那又会有什么革命性的改变呢?Grid?...哦,跑题了

因此我们还是应该宽容地看待SQL Server 2008,还是应该升级到SQL Server 2008的。

附上SQL Server 2008现在的新特性以及改进列表:

Policy-Based Management

Management/performance data collection

extended events

database mirroring enhancements

Query plan freezing

resource governor

transparent data encryption

external key management

Hot add CPU

partition aligned index views

backup compression

Table valued parameters

DDL trigger enhacements

T-SQL programming enhancements

T-SQL Intellisense

Entity data model

LINQ

Visual entity designer

Service Broker enhacements

SQLCLR enhacements

Multi-server query

Configuration servers

Hierarchy ID

Large UDTs

Date/Time data type

Improved XML support

Geography data type

Geometry data type

Filestream

Analysis Services scalable backup

Analysis Services dimension design

Star join query optimization

MERGE SQL statement

Change data capture

Analysis Services MDX enhacements

Analysis Services Personalization extensions

Analysis Services aggregation designer

Analysis Services Data Mining enhanced validation

Analysis Services Data Mining and enhanced structures

Analysis Services MOLAP writeback

Analysis Services dynamic management views

Integration Services C# scripting

Integration Services persistent look-ups

Integration Services data profiling

Integration Services import/export wizard enhancements

Integration Services Improved connectivity

Reporting Services IIS agnostic report deployments

Reporting Services report builder enhancements

Reporting Services core engine enhacements

Improved installation

Tags:SQL Server 是否

编辑录入:爽爽 [复制链接] [打 印]
赞助商链接