Inside Microsoft® SQL Server 2005: The Storage Engine

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. 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.practical, hands-on guide to understanding the intricacies of sql server 2005 architecture and storagethe proven, inside look at the sql server storage engine for developers and administrators revised for sql server 2005 delivers practical, hands-on guidance for understanding and making the most of the architecture of sql server storage, including logging and recovery, indexes, tables, transactions and locking, and security. Provides deep background information that helps developers better understand how to build more responsive databases that have fewer vulnerabilities.