Delve inside the core SQL Server engine-and put that knowledge to work-with guidance from a team of well-known internals experts. Whether database developer, architect, or administrator, you'll gain the deep knowledge you need to exploit key architectural changes-and capture the product's full potential.

Discover how SQL Server works behind the scenes, including:
* What happens internally when SQL Server builds, expands, shrinks, and moves databases
* How to use event tracking-from triggers to the Extended Events Engine
* Why the right indexes can drastically reduce your query execution time
* How to transcend normal row-size limits with new storage capabilities
* How the Query Optimizer operates
* Multiple techniques for troubleshooting problematic query plans
* When to force SQL Server to reuse a cached query plan-or create a new one
* What SQL Server checks internally when running DBCC
* How to choose among five isolation levels and two concurrency models when working with multiple concurrent users

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 Inside Microsoft SQL Server 2005: The Storage Engine and Inside Microsoft SQL Server 2005: Query Tuning and Optimization.

Paul S. Randal is a Microsoft MVP, trainer, and contributing editor for TechNet Magazine. Kimberly L. Tripp is a Microsoft MVP, trainer, and contributing editor for SQL Server Magazine. Conor Cunningham is principal architect of the SQL Server Core Engine Team at Microsoft. Adam Machanic, MCITP, is a Microsoft MVP, speaker, and contributor to several SQL Server books. Ben Nevarez has worked with SQL Server since version 6.5 and is a senior database administrator.

Product Details

* Paperback: 784 pages
* Publisher: Microsoft Press; 1 edition (March 11, 2009)
* Language: English
* ISBN-10: 0735626243
* ISBN-13: 978-0735626249