|
|
|
Copyright
|
|
|
|
Foreword
|
|
|
|
Acknowledgments
|
|
|
|
Introduction
|
|
|
|
Chapter 1. Installing and Upgrading to SQL Server 2005
|
|
|
|
|
SQL Server 2005 Prerequisites
|
|
|
|
|
Pre-Installation Decisions
|
|
|
|
|
Getting Ready to Install
|
|
|
|
|
To Migrate or Upgrade?
|
|
|
|
|
Selecting Components
|
|
|
|
|
Summary
|
|
|
|
Chapter 2. SQL Server 2005 Architecture
|
|
|
|
|
Components of the SQL Server Engine
|
|
|
|
|
Memory
|
|
|
|
|
Final Words
|
|
|
|
Chapter 3. SQL Server 2005 Configuration
|
|
|
|
|
Using SQL Server Configuration Manager
|
|
|
|
|
System Configuration
|
|
|
|
|
Final Words
|
|
|
|
Chapter 4. Databases and Database Files
|
|
|
|
|
System Databases
|
|
|
|
|
Sample Databases
|
|
|
|
|
Database Files
|
|
|
|
|
Creating a Database
|
|
|
|
|
Expanding or Shrinking a Database
|
|
|
|
|
Using Database Filegroups
|
|
|
|
|
Altering a Database
|
|
|
|
|
Databases Under the Hood
|
|
|
|
|
Setting Database Options
|
|
|
|
|
Database Snapshots
|
|
|
|
|
The tempdb Database
|
|
|
|
|
Database Security
|
|
|
|
|
Moving or Copying a Database
|
|
|
|
|
Compatibility Levels
|
|
|
|
|
Summary
|
|
|
|
Chapter 5. Logging and Recovery
|
|
|
|
|
Transaction Log Basics
|
|
|
|
|
Changes in Log Size
|
|
|
|
|
Reading the Log
|
|
|
|
|
Backing Up and Restoring a Database
|
|
|
|
|
Summary
|
|
|
|
Chapter 6. Tables
|
|
|
|
|
System Objects
|
|
|
|
|
Creating Tables
|
|
|
|
|
User-Defined Data Types
|
|
|
|
|
IDENTITY Property
|
|
|
|
|
Internal Storage
|
|
|
|
|
Constraints
|
|
|
|
|
Altering a Table
|
|
|
|
|
Summary
|
|
|
|
Chapter 7. Index Internals and Management
|
|
|
|
|
Index Organization
|
|
|
|
|
Creating an Index
|
|
|
|
|
The Structure of Index Pages
|
|
|
|
|
Index Space Requirements
|
|
|
|
|
Special Indexes
|
|
|
|
|
Table and Index Partitioning
|
|
|
|
|
Data Modification Internals
|
|
|
|
|
Managing Indexes
|
|
|
|
|
Using Indexes
|
|
|
|
|
Summary
|
|
|
|
Chapter 8. Locking and Concurrency
|
|
|
|
|
Concurrency Models
|
|
|
|
|
Transaction Processing
|
|
|
|
|
Locking
|
|
|
|
|
Lock Compatibility
|
|
|
|
|
Internal Locking Architecture
|
|
|
|
|
Bound Connections
|
|
|
|
|
Row-Level Locking vs. Page-Level Locking
|
|
|
|
|
Row Versioning
|
|
|
|
|
Other Features That Use Row Versioning
|
|
|
|
|
Controlling Locking
|
|
|
|
|
Summary
|
|
|
|
About the Author
|
|
|
|
Additional Resources for Developers
|
|
|
|
|
Visual Basic 2005
|
|
|
|
|
Visual C# 2005
|
|
|
|
|
Web Development
|
|
|
|
|
Data Access
|
|
|
|
|
SQL Server 2005
|
|
|
|
|
Other Visual Studio 2005 Topics
|
|
|
|
|
Other Developer Topics
|
|
|
|
More Great Developer Resources
|
|
|
|
|
Developer Step by Step
|
|
|
|
|
Developer Reference
|
|
|
|
|
Advanced Topics
|
|
|
|
Index
|
