Synopses & Reviews
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. Long Description Understanding the internals of storage in SQL Server helps database developers and administrators to better create, maintain, and mine information from enterprise data. This practical, hands-on book focuses on the SQL Server 2005 Storage Engine and delves deep into the structures used for storing data, including files, tables, indexes, and data types. Topics also include security details, with coverage of the new SQL Server 2005 security model, and data protection through the backup and restore algorithms. With pragmatic advice, best practices, extensive code samples, and table examples, developers and database administrators will find the guidance they need to better understand how to build powerful, efficient databases. SQL Server 2005 is Microsoft's next-generation data management and analysis solution that delivers enhanced security features, scalability, and availability to enterprise data and analytical applications while making them easier to create, deploy, and manage. Featuring key advances in enterprise data management, developer productivity, and business intelligence, SQL Server 2005 is part of the Microsoft Windows Server SystemTM--a comprehensive and integrated server infrastructure that simplifies the development, deployment, and operations of a flexible business solution.
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.
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
Discover how to:
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;