Table of Contents

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