---

Inside Microsoft SQL Server 2005: The Storage Engine (Solid Quality Learning)

ISBN: 0735621055
EAN: 2147483647

Year: 2004
Pages: 115

Authors: Kalen Delaney

BUY ON AMAZON

• 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
• 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
• SYMBOL
• A
• B
• C
• D
• E
• F
• G
• H
• I
• J
• K
• L
• M
• N
• O
• P
• Q
• R
• S
• T
• U
• V
• W
• X