Microsoft SQL Server 6 Unleashed

by Solomon, David S.; Woodbeck, Daniel; Rankins, Ray; Garbus, Jeffrey R.; McEwan, Bennett Wm; Solomon, David S.

• ISBN13: 9780672309038
• ISBN10: 0672309033
• Edition: CD
• Format: Paperback
• Copyright: 1996-03-01
• Publisher: Sams

Summary

This combination tutorial/reference teaches the reader how to develop robust systems and how to design, plan, administer, and tune both large and small databases.
-- Covers these programming topics: Referential Integrity, Stored procedures, data structures, and more
-- Teaches these administration subjects: Installation connectivity, security, performance tuning, and others
-- CD-ROM includes source code from the book, programming and administration tools, and libraries

Table of Contents

Introduction
Overview of Client/Server	p. 3
The Microsoft Client/Server Architecture	p. 13
Introduction to Transact-SQL	p. 29
Transact-SQL Datatypes	p. 69
Creating and Altering Database Objects	p. 95
Transact-SQL Programming Constructs	p. 149
Transact-SQL Program Structures	p. 199
Transaction Management	p. 233
How to Define Performance	p. 253
Understanding SQL Server Storage Structures	p. 265
Designing Indexes for Performance	p. 305
Understanding the Query Optimizer	p. 327
Stored Procedure Optimization	p. 357
Analyzing Query Plans	p. 367
Locking and Performance	p. 419
Managing the SQL Server Optimizer	p. 435
Database Design and Performance	p. 447
Database Object Placement and Performance	p. 461
Application Design for Performance	p. 481
Advanced SQL Techniques	p. 495
Miscellaneous Performance Topics	p. 511
Common Performance and Tuning Problems	p. 531
Roles and Responsibilities of the System Administrator	p. 553
SQL Server Installation and Connectivity	p. 565
Defining Physical and Mirror Devices	p. 589
Defining, Altering, and Maintaining Databases and Logs	p. 613
Security and User Administration	p. 653
Database Logging and Recovery	p. 693
SQL Server Database Backup and Restoration	p. 703
Configuring and Tuning SQL Server	p. 731
Optimizing SQL Server Configuration Options	p. 753
Measuring SQL Server System Performance	p. 769
Remote Server Management	p. 777
The Microsoft SQL Server Distributed Management Framework	p. 787
Introduction to Microsoft SQL Server 6.0 Replication	p. 807
Defining Systems Administration and Naming Standards	p. 825
Administering Very Large SQL Server Databases	p. 855
DB-Library Programming	p. 879
ODBC Programming	p. 897
Appendix: Legal Agreements Pertaining to the CD-ROM	p. 909
Index	p. 913
Table of Contents provided by Blackwell. All Rights Reserved.