
Pro SQL Server Internals
Dmitri Korotkevitch · 2014
Programming and computer science › Databases and distributed data
#13,286 most recommended
Hacker News
2
mentions by 2 people · top 79% of 15,732 books
Open Library
—
No ratings yet
2 want to read
Wikipedia
—
No article yet
About the book
A technical reference on the internal architecture of Microsoft SQL Server, covering how the engine stores data in pages, extents, tables and indexes, and how it processes queries, manages memory, and handles concurrency. It is written for developers and database administrators who work with the relational engine directly. Reliable performance tuning and sound schema design depend on knowing what the engine does underneath, not on memorized rules of thumb. The text walks through storage structures, the query optimizer and execution plans, transaction logging, locking and isolation, and memory and tempdb behavior, presenting each as the mechanism that explains observed performance and problems.
Written by Claude from what it knows of this book.
What Hacker News says 100% recommend · 0% critical
In the commenters’ own words
If you want a broad overview of how RDBMS work under the hood, "Designing Data Intensive Applications", would be a good conceptual start. This could be…
Pro SQL Server Internals by Dmitri Korotkevitch https://www.apress.com/gb/book/9781484219638 It's specific to MS SQL Server but I found the chapters on log…
What Open Library readers say
No Open Library reader has rated it yet.
- 2 want to read
- 0 reading
- 0 have read
What critics say, via Wikipedia
No Wikipedia article about this book yet, so no critics to quote.
Reddit communities — coming later
Details
- First published
- 2014
- ISBN
- 9781430259626
- Editions known
- 4 at Open Library
- Open Library
- OL19547561W
Client/server computingDatabase managementSQL server
Read next: its neighbours on the mosaic
The data model resource bookLen Silverston · 1997 · recommended by 8 people · similar by subject and what people say about it
Database InternalsAlex Petrov · 2019 · recommended by 31 people · similar by subject and what people say about it
Understanding MySQL internalsAlexander Sasha Pachev · 2006 · recommended by 2 people · similar by subject and what people say about it
Designing Data-Intensive ApplicationsMartin Kleppmann · 2017 · recommended by 457 people · similar by subject and what people say about it
SQL Performance ExplainedMarkus Winand · 2011 · recommended by 26 people · similar by subject and what people say about it
Database System ConceptsKorth · 2005 · recommended by 4 people · similar by subject and what people say about it
The art of SQLStephane Faroult · 2006 · recommended by 8 people · similar by subject and what people say about it
Windows® InternalsDavid A. Solomon · 2008 · recommended by 6 people · similar by subject and what people say about it
Database systemsHector Garcia-Molina · 2001 · recommended by 11 people · similar by subject and what people say about it
SQL for DummiesAllen G. Taylor · 1993 · recommended by 1 person · similar by subject and what people say about it
Joe Celko's SQL for SmartiesJoe Celko · 1995 · recommended by 10 people · similar by subject and what people say about it
Practical SQL, 2nd EditionAnthony DeBarros · 2021 · recommended by 5 people · similar by subject and what people say about it
Database in depthC. J. Date · 2005 · recommended by 4 people · similar by subject and what people say about it
Database design and implementationEdward Sciore · 2008 · recommended by 7 people · similar by subject and what people say about it
SQL Design PatternsVadim Tropashko · 2007 · recommended by 2 people · similar by subject and what people say about it
Windows internalsMark E. Russinovich · 2012 · recommended by 8 people · similar by subject and what people say about it
SQL antipatternsBill Karwin · 2010 · recommended by 31 people · similar by subject and what people say about it
Effective Oracle by designThomas Kyte · 2003 · recommended by 1 person · similar by subject and what people say about it
High Performance MySQLJeremy D. Zawodny · 2004 · recommended by 27 people · similar by subject and what people say about it
Database Design for Mere MortalsMichael J. Hernandez · 1996 · recommended by 12 people · similar by subject and what people say about it
Architecture of a database systemJoseph M. Hellerstein · 2007 · recommended by 7 people · similar by subject and what people say about it
Database systemsPeter Rob · 2006 · recommended by 4 people · similar by subject and what people say about it
Fundamentals of database systemsRamez Elmasri · 1989 · recommended by 2 people · similar by subject and what people say about it
Unix InternalsUresh Vahalia · 1995 · recommended by 6 people · similar by subject and what people say about it