Pro SQL Server Internals

Part 1 - Tables and Indexes

- Chapter 1: Data storage internals

- Chapter 2: Tables and Indexes - Internal Structure and Access Methods

- Chapter 3: Statistics

- Chapter 4: Special Indexing and Storage Features

- Chapter 5: Index fragmentation

- Chapter 6: Designing and tuning the indexes

Part 2: Other things that matter

- Chapter 7: Constraints

- Chapter 8: Triggers

- Chapter 9: Views

- Chapter 10: Functions

- Chapter 11: XML

- Chapter 12: Temporary Tables

- Chapter 13: CLR

- Chapter 14: CLR types

- Chapter 15: Data partitioning

- Chapter 16: System design considerations

Part 3: Locking, Blocking and Concurrency

- Chapter 17: Lock types

- Chapter 18: Troubleshooting Blocking issues

- Chapter 19: Deadlocks

- Chapter 20: Lock Escalations

- Chapter 21: Optimistic isolation levels

- Chapter 22: Application locks

- Chapter 23: Schema locks

- Chapter 24: Designing transaction strategies

Part 4: Query Life Cycle

- Chapter 25: Query Optimization and Execution

- Chapter 26: Plan Caching

Part 5: Practical Troubleshooting

- Chapter 27: System Troubleshooting

- Chapter 28: Extended events

Part 6: Inside the transaction log

- Chapter 29: Transaction Log Internals

- Chapter 30: Designing a Backup Strategy

- Chapter 31: Designing aHigh Availability Strategy

Part 7: In-Memory OLTP Engine

- Chapter 32: Hekaton (In Memory OLTP Engine)

Part 8: Columnstore Indexes

- Chapter 33: In-Memory OLTP Programmability

- Chapter 34: Introduction to Columnstore indexes

- Chapter 35: Clustered Columnstore indexes

Dmitri Korotkevitch is a Microsoft SQL Server MVP and Microsoft Certified Master who has been working with Microsoft SQL Server for more than 11 years. He specializes in architecture, design, development and performance tuning of OLTP systems and is responsible for implementation of several database backends handling thousands of transactions per second around the clock. Dmitri has a Master's degree in Computer Science and also holds an MCPD certificate.