Inside Microsoft SQL Server 2000

Kalen Delaney

Inside Microsoft SQL Server 2000
  • 出版商: MicroSoft
  • 出版日期: 2000-12-18
  • 售價: $2,330
  • 貴賓價: 9.5 折 $2,214
  • 語言: 英文
  • 頁數: 1088
  • 裝訂: Paperback
  • ISBN: 0735609985
  • ISBN-13: 9780735609983
  • 相關分類: MSSQL、SQL

    • 已過版

買這商品的人也買了...

商品描述

Description:

The definitive guide to the architecture and internals of the premier enterprise-class RDBMS

Master the inner workings of today’s premier relational database management system with this official guide to the SQL Server™ 2000 engine. Written by a renowned columnist in partnership with the product development team, this is the must-read book for anyone who needs to understand how SQL Server internal structures affect application development and functionality. Its extensive details about the latest product enhancements, updated installation and administration, and its development advice can help you create high-performance data-warehousing, transaction-processing, and decision-support applications that will scale up for any challenge. Topics covered include:

• Evolution, architecture, and toolset: The history of SQL Server since 1989, an architectural overview, and a comprehensive tour of its tools and features
• Planning and deployment: Everything you need to know about installation and deployment issues such as multiple instances, Super Sockets, and upgrades
• Databases, files, tables, and data: How to create, modify, back up, and restore databases, files, and tables; and how to query and modify data
• Built-in development tools: Using Query Analyzer and SQL Server Profiler to simplify system administration and optimize performance; programming with Transact-SQL; and extending functionality with batches, transactions, stored procedures, and triggers
• Query-processing techniques: Multiple indexes, hash and merge joins, and data-manipulation capabilities such as parallel queries
• Internal architecture: Low-level details of data and index-page structures, locking mechanisms, optimization, and plan caching
• Integration with other tools: Usage with Microsoft® Office 2000, Visual Studio® development system, and the BackOffice® server family

INCLUDED ON TWO CD-ROMS!
• A 120-day evaluation copy of Microsoft SQL Server 2000 Enterprise Edition
• A searchable electronic copy of the book
• Sample scripts
• White papers and articles
• Tools and utilities

 

 

Table of Contents:

Foreword xxi
Prefaces xxiii
System Requirements xxxv
PART I  OVERVIEW  
CHAPTER 1 THE EVOLUTION OF MICROSOFT SQL SERVER: 1989 TO 2000 3
    SQL Server: The Early Years 4
    Rons Story 6
    Kalens Story 7
    Microsoft SQL Server Ships 8
    Development Roles Evolve 10
    OS/2 and Friendly Fire 11
    SQL Server 4.2 13
        OS/2 2.0 Release on Hold 14
        Version 4.2 Released 14
    SQL Server for Windows NT 15
    Success Brings Fundamental Change 20
    The End of Joint Development 21
    The Charge to SQL95 23
    The Next Version 25
    The Secret of the Sphinx 26
    Software for the New Century 28
CHAPTER 2 A TOUR OF SQL SERVER 31
    The SQL Server Engine 33
        Transact-SQL 33
    DBMS-Enforced Data Integrity 37
        Declarative Data Integrity 38
        Datatypes 39
        CHECK Constraints and Rules 40
        Defaults 40
        Triggers 40
     Transaction Processing 42
        Atomicity 42
        Consistency 43
        Isolation 43
        Durability 43
    Symmetric Server Architecture 44
        Traditional Process/Thread Model 44
        SQL Server Process/Thread Model 45
        Multiuser Performance 45
    Security 46
        Monitoring and Managing Security 47
    High Availability 47
    Distributed Data Processing 48
    Data Replication 50
    Systems Management 52
        SQL Server Enterprise Manager 52
        Distributed Management Objects 54
        Windows Management Instrumentation 54
        SQL-DMO and Visual Basic Scripting 55
        SQL Server Agent 55
    SQL Server Utilities and Extensions 57
        Web Assistant Wizard and Internet Enabling 57
        SQL Profiler 58
        SQL Server Service Manager 59
        System Monitor Integration 60
        Client Network Utility 60
        Server Network Utility 61
        SQL Server Installation 61
        OSQL and ISQL 61
        SQL Query Analyzer 61
        Bulk Copy and Data Transformation Services 62
        SNMP Integration 63
        SQL Server Books Online 63
    Client Development Interfaces 63
        ODBC 64
        OLE DB 64
        ADO 64
        DB-Library 65
        ESQL/C 65
        Server Development Interface 65
    Summary 66
Part II  Architectural Overview  
CHAPTER 3 SQL SERVER ARCHITECTURE 69
    The SQL Server Engine 69
        The Net-Library 70
        Open Data Services 74
        The Relational Engine and the Storage Engine 77
        The Access Methods Manager 81
        The Row Operations Manager and the Index Manager 82
        The Page Manager and the Text Manager 86
        The Transaction Manager 87
        The Lock Manager 90
        Other Managers 91
    Managing Memory 91
        The Buffer Manager and Memory Pools 92
        Access to In-Memory Pages 92
        Access to Free Pages (Lazywriter) 93
        Checkpoints 95
        Accessing Pages Using the Buffer Manager 97
        Large Memory Issues 97
        The Log Manager 101
    Transaction Logging and Recovery 101
        Locking and Recovery 104
        Page LSNs and Recovery 104
    The SQL Server Kernel and Interaction with the Operating System 106
        Threading and Symmetric Multiprocessing 107
        The Worker Thread Pool 109
        Disk I/O in Windows NT/2000 111
    Summary 111
PART III  USING MICROSOFT SQL SERVER  
CHAPTER 4 PLANNING FOR AND INSTALLING SQL SERVER 115
    SQL Server Editions 116
        Embedded SQL Server 119
    Hardware Guidelines 119
        Use Hardware on the Windows Hardware Compatibility List 119
        Performance = Fn(Processor Cycles, Memory, I/O Throughput) 120
        Invest in Benchmarking 121
     Hardware Components 121
        The Processor 122
        Memory 124
        Disk Drives, Controllers, and Disk Arrays 125
        RAID Solutions 120
        More About Drives and Controllers 137
        Uninterruptible Power Supply 138
        The Disk Subsystem 139
        Fallback Server Capability 140
        Other Hardware Considerations 141
    The Operating System 141
    The File System 142
    Security and the User Context 143
    Licensing 145
        SQL Server Processor License 145
        Server Licenses and CALs 145
        Multiplexing: Use of Middleware, Transaction Servers, and Multitiered Architectures 146
        Multiple Instances 147
    Network Protocols 150
    Collation 150
        Character Sets 151
        Sort Orders 152
    Multiple Instances 157
        Installing Named Instances 158
        Named Instance Server Connectivity 159
    Installing SQL Server 160
        Upgrading from a Previous Version 161
    Basic Configuration After Installation 162
        Starting the SQL Server Service 162
        Changing the System Administrator Password 163
        Configuring SQL Servers Error Log 164
        Working with Multiple Instances 164
    Remote and Unattended Installation 166
        Remote Installation 167
        Unattended Installation 167
        Changing Installation Options 168
        Adding Additional Components 169
    Summary 170
CHAPTER 5 DATABASES AND DATABASE FILES 171
    Special System Databases 172
        master 172
        model 173
        tempdb 173
        pubs 174
        Northwind 174
        msdb 175
    Database Files 175
    Creating a Database 176
        A CREATE DATABASE Example 178
    Expanding and Shrinking a Database 179
        Automatic File Expansion 179
        Manual File Expansion 179
        Automatic File Shrinkage 179
        Manual File Shrinkage 180
    Changes in Log Size 182
        Log Truncation 185
    Using Database Filegroups 186
        The Default Filegroup 187
        A FILEGROUP CREATION Example 189
    Altering a Database 190
        ALTER DATABASE Examples 191
    Databases Under the Hood 192
        Space Allocation 194
    Setting Database Options 197
        State Options 198
        Cursor Options 202
        Auto Options 202
        SQL Options 203
        Recovery Options 205
    Other Database Considerations 205
        Databases vs. Schemas 205
        Using Removable Media 206
        Detaching and Reattaching a Database 207
        Compatibility Levels 208
    Backing Up and Restoring a Database 209
        Types of Backups 210
        Recovery Models 211
        Choosing a Backup Type 214
        Restoring a Database 215
    Summary 219
CHAPTER 6 TABLES 221
    Creating Tables 222
        Naming Tables and Columns 223
        Reserved Keywords 224
        Delimited Identifiers 224
        Naming Conventions 225
        Datatypes 226
        Much Ado About NULL 235
    User-Defined Datatypes 239
    Identity Property 241
    Internal Storage 245
        Data Pages 246
        Examining Data Pages 248
        The Structure of Data Rows 252
        Column Offset Arrays 254
        Storage of Fixed-Length and Variable-Length Rows 255
        Page Linkage 259
        Text and Image Data 260
        sql_variant Datatype 266
    Constraints 270
        PRIMARY KEY and UNIQUE Constraints 271
        FOREIGN KEY Constraints 277
        Constraint-Checking Solutions 286
        Restrictions on Dropping Tables 287
        Self-Referencing Tables 287
        CHECK Constraints 289
        Default Constraints 294
        More About Constraints 298
    Altering a Table 306
        Changing a Datatype 306
        Adding a New Column 308
        Adding, Dropping, Disabling, or Enabling a Constraint 308
        Dropping a Column 309
        Enabling or Disabling a Trigger 309
    Temporary Tables 309
        Private Temporary Tables (#) 310
        Global Temporary Tables (##) 310
        Direct Use of tempdb 311
        Constraints on Temporary Tables 311
    System Tables 312
    Summary 315
CHAPTER 7 QUERYING DATA 317
    The SELECT Statement 317
    Joins 320
        Outer Joins 324
        The Obsolete *= OUTER JOIN Operator 329
        Cross Joins 335
    Dealing with NULL 336
        NULL in the Real World 340
        IS NULL and = NULL 343
    Subqueries 345
        Correlated Subqueries 350
    Views and Derived Tables 357
        Altering Views 361
        Partitioned Views 362
    Other Search Expressions 365
        LIKE 365
        BETWEEN 371
        Aggregate Functions 371
        Datacube—Aggregate Variations 378
        TOP 392
        UNION 395
    Summary 401

類似商品