Chapter 2. What’s New in SQL Server 2005


The upgrade from SQL Server 6.5 to 7.0 was pretty significant. In addition to many new features, the underlying SQL Server architecture changed considerably. In comparison, the upgrade from SQL Server 7.0 to 2000 was more of a series of enhancements, additions, and improvements.

Microsoft SQL Server 2005 further extends the performance, reliability, availability, programmability, and ease of use of SQL Server 2000. SQL Server 2005 includes several new features that make it an excellent database platform for large-scale online transaction processing (OLTP), data warehousing, and e-commerce applications.

This chapter explores the new features ...

Get Microsoft® SQL Server 2005 Unleashed now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.