documentation.HELP! SQL Server Architecture Documentation

SQL Server Architecture

SQL Server Architecture

Table of contents

• SQL Server Architecture Overview
• Fundamentals of SQL Server 2000 Architecture
  • SQL Server 2000 Component Overview
• Features of SQL Server 2000
  • Integrated with the Internet
  • Scalability and Availability
  • Enterprise-Level Database Features
  • Ease of Installation, Deployment, and Use
  • Data Warehousing
• Relational Database Components
  • Database Applications and Servers
  • Logins
  • Client Components
  • Communication Components
    • Client and Server Net-Libraries
    • Controlling Net-Libraries and Communications Addresses
    • Tabular Data Stream Protocol
    • Net-Library Encryption
  • Server Components
    • SQL Server Service
    • SQL Server Agent Service
    • Microsoft Search Service
    • MSSQLServerADHelper Service
    • MS DTC Service
    • Multiple Instances of SQL Server
      • Communicating with Multiple Instances
      • Using Multiple Instances
      • Working with Multiple Instances
    • Federated SQL Server 2000 Servers
      • Partitioning Data
    • Failover Clustering Architecture
      • SQL Server 2000 Failover Clusters
    • Active Directory Integration
• SQL Server and XML Support
• Database Architecture
  • Logical Database Components
    • Data Types and Table Structures
    • SQL Views
    • SQL Stored Procedures
    • SQL User-Defined Functions
    • Constraints, Rules, Defaults, and Triggers
      • Constraints
      • Rules
      • Defaults
      • Triggers
    • Collations
      • SQL Server Collation Fundamentals
      • Selecting Collations
      • Specifying Collations
        • Specifying the Default Collation for an Instance of SQL Server
      • Mixed Collation Environments
      • Changing Collations
    • SQL Indexes
      • Table Indexes
      • View Indexes
      • Maximum Size of Index Keys
    • Property Management
    • Full-Text Catalogs and Indexes
    • Logins, Users, Roles, and Groups
      • Logins
      • Users
      • Roles
      • Groups
    • Owners and Permissions
    • Session Context Information
  • System Databases and Data
  • Physical Database Architecture
    • Pages and Extents
    • Physical Database Files and Filegroups
    • Space Allocation and Reuse
      • Managing Extent Allocations and Free Space
      • Managing Space Used by Objects
      • Tracking Modified Extents
      • Shrinking Databases
    • Table and Index Architecture
      • Distribution Statistics
      • Heap Structures
      • Clustered Indexes
      • Nonclustered Indexes
      • tempdb and Index Creation
      • text, ntext, and image Data
        • ntext, text, and image Data When text in row Is Set to OFF
        • text, ntext, and image Data When text in row Is Set to ON
    • Transaction Log Architecture
      • Write-Ahead Transaction Log
      • Transaction Log Logical Architecture
      • Checkpoints and the Active Portion of the Log
      • Truncating the Transaction Log
      • Transaction Log Physical Architecture
      • Shrinking the Transaction Log
• Relational Database Engine Architecture
  • Relational Database Engine Architecture Overview
    • Database Engine Components
      • Relational Engine
      • Storage Engine
      • SQL Server Language Support
  • Query Processor Architecture
    • Single SQL Statement Processing
      • View Resolution
        • Resolving Indexes on Views
        • Resolving Distributed Partitioned Views
      • Worktables
    • Batch Processing
    • Stored Procedure and Trigger Execution
    • Execution Plan Caching and Reuse
      • Parameters and Execution Plan Reuse
      • Auto-Parameterization
      • Preparing SQL Statements
    • Parallel Query Processing
      • Degree of Parallelism
      • Parallel Query Example
      • Parallel Operations Creating Indexes
  • Memory Architecture
    • Dynamically Managing Memory on Windows NT and Windows 2000
      • Effects of min and max server memory
      • Dynamically Managing Memory Between Multiple Instances
    • Dynamically Managing Memory on Windows 95 and Windows 98
    • Using AWE Memory on Windows 2000
    • SQL Server Memory Pool
  • Thread and Task Architecture
    • SQL Server Task Scheduling
      • Allocating Threads to a CPU
      • Using the lightweight pooling Option
    • Thread and Fiber Execution
  • I/O Architecture
    • Reading Pages
    • Freeing and Writing Buffer Pages
  • Distributed Query Architecture
  • Full-Text Query Architecture
    • Full-Text Indexing Support
    • Full-Text Querying Support
  • Extended Stored Procedure Architecture
  • Remote Stored Procedure Architecture
  • Transactions Architecture
    • Transaction Recovery
    • Concurrency Architecture
    • Locking Architecture
      • Latching
    • Distributed Transactions Architecture
  • Cursor Architecture
  • Server Scalability
    • SQL Server 2000 on Large Servers
    • SQL Server 2000 Databases on the Desktop
    • SQL Server 2000 on Windows 98
    • SQL Server 2000 and Windows CE
  • SQL Server and Mail Integration
• Administration Architecture
  • DDL and Stored Procedures
  • SQL Distributed Management Framework
    • SQL-DMF Applications
    • SQL-DMF APIs
    • SQL Server Agent
  • Graphical Tools
    • SQL Server Enterprise Manager
    • SQL Query Analyzer
    • Windows 2000 System Monitor
    • Import and Export Data
    • SQL Profiler
    • SQL Server Service Manager
    • Client Network Utility
    • Server Network Utility
    • Miscellaneous Utilities
  • Automated Administration Architecture
  • Backup/Restore Architecture
    • Backup Devices
    • Types of Backup and Restore Processes
      • Database Backup and Restore
      • Transaction Log Backup and Restore
      • Differential Backup and Restore
      • File and Filegroup Backup and Restore
    • Fuzzy Backup and Restore Operations
    • Parallel Backup and Restore
  • Data Import/Export Architecture
  • Data Integrity Validation
• Replication Architecture
• Data Warehousing and Online Analytical Processing
  • Transforming OLTP Data to OLAP Data Warehouses
  • SQL Server 2000 Data Warehouse and OLAP Components
• 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
• Implementation Details
  • Editions of SQL Server 2000
    • Operating Systems Supported by the Editions of SQL Server 2000
    • Features Supported by the Editions of SQL Server 2000
  • Maximum Capacity Specifications
  • Configuration Option Specifications
  • Memory Used by SQL Server Objects Specifications

next page

Get in touch

Submit feedback about this site to:

• [email protected]