Pro SQL Server Internals

by Dmitri Korotkevitch

Pro SQL Server Internals explains how different SQL Server components work "under the hood" and how they communicate with each other. This is the practical book with a large number of examples that will show you how various design and implementation decisions affect the behavior and performance of your systems. Pro SQL Server Internals covers a multiple SQL Server versions starting with SQL Server 2005 all the way up to the recently released SQL Server 2014. You’ll learn about new SQL Server 2014 features including the new Cardinality Estimator, In-Memory OLTP Engine (codename Hekaton), and Clustered Columnstore Indexes. With Pro SQL Server Internals , you have a solid roadmap for understanding the depth and power of the SQL Server database backend, regardless of the version and edition of SQL Server you use. Pro SQL Server Internals does the

Genres: Technical

804 pages, Paperback

First published January 22, 2014

Reviews

[Sebastian Gebski · Rating 5 out of 5]

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.