Inside Microsoft SQL Server 2000 - Brossura

Kalen, Delaney; Delaney, Kalen

Brossura

ISBN 10: 0735609985 ISBN 13: 9780735609983

Casa editrice: Microsoft Pr, 2000

Riassunto

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 familyINCLUDED 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

Su questo libro

L'autore

Over 60 SQL Server MVPs contributed to this book, which was assembled and edited by Kalen Delaney and SQL Server legends Louis Davidson (Database Design and Architecture), Greg Low (Business Intelligence.), Brad McGhee (Performance Tuning and Optimization), Paul Nielson (Database Development), and Paul Randal and Kimberly Tripp (Database Administration.)

Contenuti

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

Ron’s Story 6

Kalen’s 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

Dettagli dell?edizione

• Editore: Microsoft Pr
• Data di pubblicazione: 2000
• ISBN 10: 0735609985
• ISBN 13: 9780735609983
• Rilegatura: Copertina flessibile
• Lingua: Inglese
• Numero edizione: 1
• Numero di pagine: 1046