Inside Microsoft SQL Server 2005: The Storage Engine (Solid Quality Learning) - page 1
- 1
- 2
- Inside Microsoft SQL Server 2005: The Storage Engine
- Inside Microsoft SQL Server 2005: The Storage Engine
- Table of Contents
- 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
- 1
- 2
