SQL Server 2008是否是SQL Server 2005的一个补丁包
2008-09-02 09:58:15 来源:WEB开发网随着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
- ››SQL Server 2008 R2 下如何清理数据库日志文件
- ››sqlite 存取中文的解决方法
- ››SQL2005、2008、2000 清空删除日志
- ››SQL Server 2005和SQL Server 2000数据的相互导入...
- ››sql server 2008 在安装了活动目录以后无法启动服...
- ››sqlserver 每30分自动生成一次
- ››sqlite 数据库 对 BOOL型 数据的插入处理正确用法...
- ››sql server自动生成批量执行SQL脚本的批处理
- ››sql server 2008亿万数据性能优化
- ››SQL Server 2008清空数据库日志方法
- ››sqlserver安装和简单的使用
- ››SQL Sever 2008 R2 数据库管理
更多精彩
赞助商链接