SQL Server Architecture
Table of contents
- SQL Server Architecture Overview
- Fundamentals of SQL Server 2000 Architecture
- Features of SQL Server 2000
-
Relational Database Components
- Database Applications and Servers
- Logins
- Client Components
- Communication Components
- Server Components
- SQL Server and XML Support
-
Database Architecture
- Logical Database Components
- System Databases and Data
- Physical Database Architecture
-
Relational Database Engine Architecture
- Relational Database Engine Architecture Overview
- Query Processor Architecture
- Memory Architecture
- Thread and Task Architecture
- I/O Architecture
- Distributed Query Architecture
- Full-Text Query Architecture
- Extended Stored Procedure Architecture
- Remote Stored Procedure Architecture
- Transactions Architecture
- Cursor Architecture
- Server Scalability
- SQL Server and Mail Integration
- Administration Architecture
- Replication Architecture
- Data Warehousing and Online Analytical Processing
-
Application Development Architecture
-
Choosing an API
- SQL Server and ADO
- SQL Server and Universal Resource Locators
- SQL Server and OLE DB
- SQL Server and ODBC
- SQL-DMO API
- SQL Namespace API
- Replication Component Programming API
- Data Transformation Services API
- SQL Server and English Query
- Extended Stored Procedure API
- SQL Server and Embedded SQL
- DB-Library API
- SQL Syntax Recommendations
-
Choosing an API
- Implementation Details