Inside Microsoft SQL Server 2005: The Storage Engine


book cover
Inside Microsoft® SQL Server™ 2005: The Storage Engine
By Kalen Delaney -  (Solid Quality Learning)
...............................................
Publisher: Microsoft Press
Pub Date: October 11, 2006
Print ISBN-10: 0-7356-2105-5
Print ISBN-13: 978-0-7356-2105-3
Pages: 464
 

Table of Contents  | Index
overview

This practical, hands-on book offers deep, thorough coverage of the internals of architecture and resource management in SQL Server 2005, focusing on the Storage Engine. The book features extensive code samples and table examples.



book cover
Inside Microsoft® SQL Server™ 2005: The Storage Engine
By Kalen Delaney -  (Solid Quality Learning)
...............................................
Publisher: Microsoft Press
Pub Date: October 11, 2006
Print ISBN-10: 0-7356-2105-5
Print ISBN-13: 978-0-7356-2105-3
Pages: 464
 

Table of Contents  | Index

   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