Pro SQL Server Internals (Paperback)

Part 1: Tables and Indexes 1. Data Storage Internals 2. Tables and Indexes 3. Statistics 4. Special Indexing and Storage Features 5. SQL Server 2016 Enhancements 6. Index Fragmentation 7. Designing and Tuning the Indexes Part 2: Other Things That Matter 8. Constraints 9. Triggers 10. Views 11. Functions 12. XML and JSON 13. Temporary Tables and TempDB 14. CLR 15. CLR Types 16. Data Partitioning Part 3: Locking, Blocking, and Concurrency 17. Lock Types and Transaction Isolation Levels 18. Troubleshooting Blocking Issues 19. Deadlocks 20. Lock Escalations 21. Optimistic Isolation Levels 22. Application Locks 23. Schema Locks 24. Designing Transaction Strategies Part 4: Query Life Cycle 25. Query Optimization and Execution 26. Plan Caching Part 5: Practical Troubleshooting 27. System Troubleshooting 28. Extended events 29. Query Store Part 6: Inside the Transaction Log 30. Transaction Log Internals 31. Backup and Restore 32. High Availability Technologies Part 7: In-Memory OLTP Engine 33. Column-Based Storage and Batch Mode Execution 34. Columnstore Indexes Part 8: In-Memory OLTP Engine 35. In-Memory OLTP Internals 36. Transaction Processing in In-Memory OLTP 37. In-Memory OLTP Programmability