Inside Microsoft SQL Server 2000
暫譯: 深入探討 Microsoft SQL Server 2000

Kalen Delaney

Inside Microsoft SQL Server 2000
  • 出版商: MicroSoft
  • 出版日期: 2000-12-18
  • 售價: $2,370
  • 貴賓價: 9.5 折 $2,252
  • 語言: 英文
  • 頁數: 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

商品描述(中文翻譯)

描述：
這是關於頂級企業級關聯式資料庫管理系統（RDBMS）架構和內部運作的權威指南。透過這本官方指南，掌握當今頂級關聯式資料庫管理系統 SQL Server™ 2000 引擎的內部運作。這本書由知名專欄作家與產品開發團隊合作撰寫，是任何需要了解 SQL Server 內部結構如何影響應用程式開發和功能的讀者必讀的書籍。書中詳細介紹了最新的產品增強、更新的安裝和管理，以及開發建議，幫助您創建高效能的資料倉儲、交易處理和決策支援應用程式，能夠應對各種挑戰。涵蓋的主題包括：

• 演變、架構和工具集：自1989年以來 SQL Server 的歷史、架構概述，以及其工具和功能的全面介紹
• 計畫與部署：有關安裝和部署問題的所有知識，例如多個實例、Super Sockets 和升級
• 資料庫、檔案、表格和資料：如何創建、修改、備份和還原資料庫、檔案和表格；以及如何查詢和修改資料
• 內建開發工具：使用 Query Analyzer 和 SQL Server Profiler 簡化系統管理和優化性能；使用 Transact-SQL 進行編程；以及通過批次、交易、儲存過程和觸發器擴展功能
• 查詢處理技術：多重索引、哈希和合併連接，以及平行查詢等資料操作能力
• 內部架構：資料和索引頁面結構的低層次細節、鎖定機制、優化和計畫快取
• 與其他工具的整合：與 Microsoft® Office 2000、Visual Studio® 開發系統和 BackOffice® 伺服器系列的使用

包含兩張 CD-ROM！
• 一份 120 天的 Microsoft SQL Server 2000 企業版評估版
• 一本可搜尋的電子書副本
• 範本腳本
• 白皮書和文章
• 工具和實用程式

目錄：
前言
xxi
序言
xxiii
系統需求
xxxv
第一部分 概述
第一章 微軟 SQL Server 的演變：1989 到 2000
3
SQL Server：早期的歲月
4
Ron 的故事
6
Kalen 的故事
7
微軟 SQL Server 發佈
8
開發角色的演變
10
OS/2 和友善火力
11
SQL Server 4.2
13
OS/2 2.0 版本延遲
14
版本 4.2 發佈
14
Windows NT 的 SQL Server
15
成功帶來根本變化
20
聯合開發的結束
21
對 SQL95 的挑戰
23
下一個版本
25
斯芬克斯的秘密
26
新世紀的軟體
28
第二章 SQL Server 之旅
31
SQL Server 引擎
33
Transact-SQL
33
DBMS 強制資料完整性
37
聲明式資料完整性
38
資料類型
39
CHECK 約束和規則
40
預設值
40
觸發器
40
交易處理
42
原子性
42
一致性
43
隔離性
43
持久性
43
對稱伺服器架構
44
傳統的過程/執行緒模型
44
SQL Server 過程/執行緒模型
45
多用戶性能
45
安全性
46
監控和管理安全性
47
高可用性
47
分散式資料處理
48
資料複製
50
系統管理
52
SQL Server 企業管理員
52
分散式管理物件
54

類似商品