What do you think?
Rate this book
Pro SQL Server Internals
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
- GenresTechnical
840 pages, Paperback
First published January 22, 2014
30 people are currently reading
65 people want to read
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 of 1 review
October 25, 2014
Best book on SQL Server I've ever read. By far.
To be honest I had considered myself pretty advanced on the topic, but I've learned so much from this book, that it has made me revise this opinion. Author dives into really low-level details that shed completely new light on how SQL Server works under the hood. What is also important - regardless of topic's complexity and overwhelming number of details, the book is still readable and comprehensible.
What did I miss? I was a bit disappointed that low level description of latches was ommitted & there were some chapters that were almost screaming for some cookbook-style, more elaborate examples.
But otherwise than these, book is almost perfect. Highly recommended read.
To be honest I had considered myself pretty advanced on the topic, but I've learned so much from this book, that it has made me revise this opinion. Author dives into really low-level details that shed completely new light on how SQL Server works under the hood. What is also important - regardless of topic's complexity and overwhelming number of details, the book is still readable and comprehensible.
What did I miss? I was a bit disappointed that low level description of latches was ommitted & there were some chapters that were almost screaming for some cookbook-style, more elaborate examples.
But otherwise than these, book is almost perfect. Highly recommended read.
Displaying 1 of 1 review