SQL Server 2008 Internals
The definitive deep-dive on core engine features & how they work
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
The Contents of "SQL Server 2008 Internals" at a Glance:
- SQL Server 2008 Architecture and Configuration 1
- Change Tracking, Tracing, and Extended Events 75
- Databases and Database Files 125
- Logging and Recovery 181
- Tables 211
- Indexes: Internals and Management 299
- Special Storage 375
- The Query Optimizer 443
- Plan Caching and Recompilation 525
- Transactions and Concurrency 587
- DBCC Internals 663
- Index 729
About the Authors Kalen Delaney, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Adam Machanic, and Benjamin Nevarez:Kalen Delaney has been working with Microsoft SQL Server for over 21 years, and she provides advanced SQL Server training to clients around the world. She has been a SQL Server MVP (Most Valuable Professional) since 1992 and has been writing about SQL Server almost as long. Kalen has spoken at dozens of technical conferences, including every PASS Community Summit held in the United States since the organization´s founding in 1999. Kalen is a partner and Director of Training for SQL Tuners (www.sqltuners.net), a SQL Server tuning and managed services company based in the northwestern United States.
Kalen is a contributing editor and columnist for SQL Server Magazine and the author or co-author of several Microsoft Press books on SQL Server, including Inside Microsoft SQL Server 7, Inside Microsoft SQL Server 2000, Inside Microsoft SQL Server 2005: The Storage Engine, and Inside Microsoft SQL Server 2005: Query Tuning and Optimization.
Paul S. Randal is the managing director of SQLskills.com, which he runs with his wife, Kimberly L. Tripp. He is also a SQL Server MVP and one of the contributing editors of TechNet Magazine. Paul joined Microsoft in 1999 after spending five years at DEC working on the OpenVMS file system. He wrote various DBCC commands for SQL Server 2000 and then rewrote all of DBCC CHECKDB for SQL Server 2005 before moving into management on the SQL Server team. During SQL Server 2008 development, he was responsible for the entire Storage Engine.
Paul regularly teaches classes on topics such as database maintenance, high availability, disaster recovery, and SQL Server internals. He is a top-rated presenter at worldwide Tech-Ed and co-chairs the SQL Server Connections conferences. In the last year, Paul has written a large number of SQL Server 2008 materials, including white papers, and articles for TechNet Magazine.
Kimberly L. Tripp is the president/founder of SQLskills.com, which she started in 1995 after leaving Microsoft, where she held multiple positions, including technical writer for the SQL Server Team and subject matter expert/trainer for Microsoft University. She is a SQL Server MVP, a Microsoft regional director, and a contributing editor of SQL Server Magazine. Since 1990, Kimberly has focused on many aspects of SQL Server availability, with emphasis on performance tuning and optimization.
Kimberly regularly teaches classes on topics such as database design, performance tuning, database maintenance, and SQL Server internals. She is a top-rated presenter at worldwide Tech-Ed conferences and the PASS Community Summit, and she co-chairs the SQL Server Connections conferences with Paul Randal. Kimberly has worked with all releases of SQL Server since version 1.0 and has written numerous resources, including online content and webcasts, white papers, and most recently, the Microsoft SQL 2008 JumpStart training class for DBAs.
Conor Cunningham is principal architect of the SQL Server Core Engine Team, with over 10 years experience building database engines for Microsoft. He specializes in query processing and query optimization, and he designed and/ or implemented a number of the query processing features available in SQL Server. Conor holds a number of patents in the field of query optimization, and he has written numerous academic papers on query processing.
Adam Machanic is a Boston-based independent database consultant, writer, and speaker. He has been involved in dozens of SQL Server implementations for both high-availability OLTP and large-scale data warehouse applications, and he has optimized data access layer performance for several data-intensive applications. Adam has written for numerous Web sites and magazines, including SQLBlog, Simple Talk, Search SQL Server, SQL Server Professional, CoDe, and Visual Systems Journal. He has also contributed to several books on SQL Server, including Expert SQL Server 2005 Development (Apress, 2007) and Inside SQL Server 2005: Query Tuning and Optimization (Microsoft Press, 2007). Adam regularly speaks at user groups, community events, and conferences on a variety of SQL Server- and .NET-related topics. He is a SQL Server MVP, a Microsoft Certified IT Professional (MCITP), and a member of the INETA North American Speakers Bureau.
Technical Reviewer: Benjamin Nevarez
Ben Nevarez has 15 years of experience with relational databases and has worked with SQL Server since version 6.5. He holds a master´s degree in computer science and has been a speaker at several technology conferences, including the PASS Community Summit. Ben is currently a senior database administrator with the American International Group (AIG). When he is not working with SQL Server, Ben spends time with his wife, Rocio, and his three sons, David, Benjamin, and Diego.