Contents at a Glance
Chapter 1: Data Storage Internals
Chapter 2: Tables and Indexes: Internal Structure and Access Methods
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 10: User-Defined Functions
Chapter 16: System Design Considerations
Part 3: Locking, Blocking and Concurrency
Chapter 18: Troubleshooting Blocking Issues
Chapter 21: Optimistic Isolation Levels
Chapter 24: Designing Transaction Strategies
Chapter 25: Query Optimization and Execution
Part 5: Practical Troubleshooting
Chapter 27: System Troubleshooting
Part 6: Inside the transaction log
Chapter 29: Transaction Log Internals
Chapter 30: Designing a Backup Strategy
Chapter 31: Designing a High Availability Strategy
Chapter 32: In-Memory OLTP Internals
Chapter 33: In-Memory OLTP Programmability
Chapter 34: Introduction to Columnstore Indexes