O'Reilly logo

Microsoft® SQL Server 2005: Changing the Paradigm (SQL Server 2005 Public Beta Edition) by Scalability Experts, Inc.

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 2. SQL Server 2005 Database Engine Architectural Changes

IN THIS CHAPTER

The SQL Server Operating System (SQLOS)

Non-Uniform Memory Access (NUMA) Architecture Support

Query Optimization and Execution

Row Versioning

System Metadata Access and the Security Architecture

Storage Engine and I/O Changes

SQL Server 2005 is loaded with features related to scalability, reliability, performance, high availability, programmability, security, and manageability. These features and enhancements are the primary drivers for the major overhauls in several areas of the database engine to accommodate a seamless integration throughout. Microsoft has made changes to SQL Server’s memory management, thread scheduling, statistics management, parallelism, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required