DeepRead
Cover of Pro SQL Server Internals

Pro SQL Server Internals

Dmitri Korotkevitch · 2014

Programming and computer science › Databases and distributed data

#13,286 most recommended

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

012201820192018 peak · 1
This bookAverage book in Databases and distributed data

In the commenters’ own words

What Open Library readers say

No Open Library reader has rated it yet.

  • 2 want to read
  • 0 reading
  • 0 have read

Open Library’s page for the book

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

Explore in the mosaic

Read next: its neighbours on the mosaic

  • The data model resource book
    Len Silverston · 1997 · recommended by 8 people · similar by subject and what people say about it
  • Database Internals
    Alex Petrov · 2019 · recommended by 31 people · similar by subject and what people say about it
  • Understanding MySQL internals
    Alexander Sasha Pachev · 2006 · recommended by 2 people · similar by subject and what people say about it
  • Designing Data-Intensive Applications
    Martin Kleppmann · 2017 · recommended by 457 people · similar by subject and what people say about it
  • SQL Performance Explained
    Markus Winand · 2011 · recommended by 26 people · similar by subject and what people say about it
  • Database System Concepts
    Korth · 2005 · recommended by 4 people · similar by subject and what people say about it
  • The art of SQL
    Stephane Faroult · 2006 · recommended by 8 people · similar by subject and what people say about it
  • Windows® Internals
    David A. Solomon · 2008 · recommended by 6 people · similar by subject and what people say about it
  • Database systems
    Hector Garcia-Molina · 2001 · recommended by 11 people · similar by subject and what people say about it
  • SQL for Dummies
    Allen G. Taylor · 1993 · recommended by 1 person · similar by subject and what people say about it
  • Joe Celko's SQL for Smarties
    Joe Celko · 1995 · recommended by 10 people · similar by subject and what people say about it
  • Practical SQL, 2nd Edition
    Anthony DeBarros · 2021 · recommended by 5 people · similar by subject and what people say about it
  • Database in depth
    C. J. Date · 2005 · recommended by 4 people · similar by subject and what people say about it
  • Database design and implementation
    Edward Sciore · 2008 · recommended by 7 people · similar by subject and what people say about it
  • SQL Design Patterns
    Vadim Tropashko · 2007 · recommended by 2 people · similar by subject and what people say about it
  • Windows internals
    Mark E. Russinovich · 2012 · recommended by 8 people · similar by subject and what people say about it
  • SQL antipatterns
    Bill Karwin · 2010 · recommended by 31 people · similar by subject and what people say about it
  • Effective Oracle by design
    Thomas Kyte · 2003 · recommended by 1 person · similar by subject and what people say about it
  • High Performance MySQL
    Jeremy D. Zawodny · 2004 · recommended by 27 people · similar by subject and what people say about it
  • Database Design for Mere Mortals
    Michael J. Hernandez · 1996 · recommended by 12 people · similar by subject and what people say about it
  • Architecture of a database system
    Joseph M. Hellerstein · 2007 · recommended by 7 people · similar by subject and what people say about it
  • Database systems
    Peter Rob · 2006 · recommended by 4 people · similar by subject and what people say about it
  • Fundamentals of database systems
    Ramez Elmasri · 1989 · recommended by 2 people · similar by subject and what people say about it
  • Unix Internals
    Uresh Vahalia · 1995 · recommended by 6 people · similar by subject and what people say about it