Chapter 16. Architecture Features
by Mark Spenik
IN THIS CHAPTER
SQL Server Thread Scheduling
Disk I/O and Data Management
Multiple Database Instances
Federated Database Servers
Other Enhancements
SQL Server 7.0 was a major rewrite of previous versions of SQL Server and is the foundation for SQL Server 2000 along with some enhancements such as XML, multiple instances, and federated database servers. This chapter focuses on some of the SQL Server internals that have not been discussed in detail in previous chapters. Most of these features changed very little from SQL Server 7.0 to SQL Server 2000, but the changes compared between previous versions and SQL Server 7.0 and SQL Server 2000 are stark. To highlight the improved architecture for reliability ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
