Synopses & Reviews
Take an in-depth look at the internals of the SQL Server Storage Engine—with advice from a popular author and SQL Server expert. Database developers and administrators get best practices, pragmatic advice, and code samples to help master the intricacies of creating and maintaining enterprise relational databases.
Discover how to:
Upgrade or migrate to SQL Server 2005 and choose configuration options Control space allocation for databases and files manually or automatically Manage transaction logs to maximize efficient restore operations and data consistency Observe the internal structures of clustered and nonclustered indexes Build and partition relational indexes and tables Explore internal storage issues and compare fixed- and variable-length datatypes Detect and correct index fragmentation Implement and manage an appropriate concurrency model using locking or row versioning
PLUS—Get code samples on the Web.
About the Author
Kalen Delaney, a Microsoft MVP for SQL Server since 1993, provides advanced SQL Server training to clients worldwide. She is a contributing editor and columnist for SQL Server Magazine and the author of several highly regarded books, including Microsoft SQL Server 2008 Internals.
Table of Contents
Foreword; Acknowledgments; Introduction; A History of Inside Microsoft SQL Server; Series Structure; Examples and Scripts; Topics Not Covered; Caveats and Disclaimers; How to Get Support; 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; Appendix : About the Author; Appendix : 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; Appendix : More Great Developer Resources; Developer Step by Step; Developer Reference; Advanced Topics;