9780735626249

Explore the definitive guide to the internals and architecture of the Microsoft SQL Server 2008 relational database engine. The author-an expert on SQL Server internals-offers the guidance developers and database administrators need to understand how SQL Server internal structures affect application development and functionality. Get the practical guidance needed to understand and maximize the SQL Server architecture, including information about logging and recovery, indexes, tables, transactions and locking, and security. This complete reference offers numerous code samples, table examples, and practical advice.

Conor Cunningham is principal architect of the SQL Server Core Engine Team at Microsoft.

Foreword
Introduction
SQL Server 2008 Architecture and Configuration
Change Tracking, Tracing, and Extended Events
Databases and Database Files
Logging and Recovery
Tables
Indexes: Internals and Management
Special Storage
The Query Optimizer
Plan Caching and Recompilation
Transactions and Concurrency
DBCC Internals
Appendix : About the Authors
Table of Contents provided by Publisher. All Rights Reserved.

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Amazon no longer offers textbook rentals. We do!

Microsoft Sql Server 2008 Internals

Microsoft Sql Server 2008 Internals

0735626243

Summary

Author Biography

Table of Contents

Supplemental Materials

Write a Review