关于SQL Server 2008是否是SQL Server 2005的一个Service Pack-优快云博客

本文探讨了SQL Server 2008相较于2005版的改进之处，强调其并非简单的补丁包，而是拥有众多新增功能如资源管理器(Resource Governor)、声明式管理框架(Declarative Management Framework)等。文章还列出了SQL Server 2008的所有新特性及改进。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

随着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的，升级有问题可以咨询EMC MSP么，哈哈哈~~~~！

附上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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9079672/viewspace-217107/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9079672/viewspace-217107/