IN THIS CHAPTER
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 ...