Microsoft SQL Server 2000 Unleashed

Microsoft® SQL Server 2000 Unleashed offers a variety of topics for system and database administrators to help them learn new features of the product and to solve problems they face on a daily basis. It shows them how to build upon their working knowledge of the product and take their experience and knowledge to a higher level. This title includes topics such as: SQL Server and XML; high availability; SQL Server architecture; performance and tuning; SQL Server and the Web; scalability issues; integration with BackOffice and other Microsoft® products; enterprise issues; replication; Data Transformation Services (DTS); security; and analysis services. This book is written by authors who offer the benefits of their experiences to help readers understand and solve problems such as performance issues, implementing critical backup and recovery strategies, and code efficient applications that work across a variety of platforms and systems.

Introduction

1

(6)

Part I Welcome to Microsoft SQL Server

7

(46)

The Microsoft SQL Server Environment

9

(20)

SQL Server 2000 Environments and Editions

29

(14)

What's New in SQL Server 2000

43

(10)

Part II Installation and Upgrade

53

(44)

Installing a New SQL Server Instance

55

(20)

Client Installation and Configuration

75

(22)

Part III SQL Server Administration Tasks and Tools

97

(570)

SQL Server System and Database Administration

99

(12)

SQL Server Enterprise Manager

111

(28)

SQL Server Command-Line Utilities

139

(16)

Creating and Managing Databases

155

(20)

Creating and Managing Tables in SQL Server

175

(24)

Creating and Managing Indexes

199

(8)

Data Integrity

207

(20)

Creating and Managing Views in SQL Server

227

(16)

Creating and Managing Stored Procedures

243

(86)

Creating and Managing Triggers

329

(32)

User-Defined Functions

361

(26)

Security and User Administration

387

(22)

Database Backup and Recovery

409

(40)

Database Maintenance

449

(14)

SQL Server Scheduling and Notification

463

(16)

Managing Linked and Remote Servers

479

(26)

Importing and Exporting SQL Server Data Using BCP

505

(40)

Importing and Exporting SQL Server Data Using Data Transformation Services (DTS)

545

(24)

Administering Very Large SQL Server Databases

569

(8)

Data Replication

577

(60)

Defining SQL Server Environment and Naming Standards

637

(30)

Part IV Transact-SQL

667

(176)

Using Transact-SQL in SQL Server 2000

669

(112)

Transaction Management and the Transaction Log

781

(40)

Distributed Transaction Processing

821

(22)

Part V SQL Server Internals and Performance Turning

843

(444)

SQL Server Internals

845

(106)

Indexes and Performance

951

(48)

Understanding Query Optimization

999

(62)

Query Analysis

1061

(30)

Using the SQL Server Profiler

1091

(26)

Using the SQL Debugger in Query Analyzer

1117

(8)

Monitoring SQL Server Performance

1125

(26)

Locking and Performance

1151

(64)

Database Design and Performance

1215

(40)

Configuring, Tuning, and Optimizing SQL Server Options

1255

(32)

Part VI Integrating SQL Server into the Microsoft Architecture

1287

(156)

SQL Mail

1289

(26)

Using XML in SQL Server 2000

1315

(32)

Microsoft SQL Server Analysis Services

1347

(46)

Microsoft Transaction Server

1393

(24)

SQL Server Clustering

1417

(12)

Full Text Search

1429

(14)

Index

1443

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.