Advertisement

Pro SQL Server Internals

  • Authors
  • Dmitri Korotkevitch

Table of contents

  1. Front Matter
    Pages i-xxxi
  2. Tables and Indexes

    1. Front Matter
      Pages 1-1
    2. Dmitri Korotkevitch
      Pages 3-27
    3. Dmitri Korotkevitch
      Pages 53-80
    4. Dmitri Korotkevitch
      Pages 81-112
    5. Dmitri Korotkevitch
      Pages 113-124
    6. Dmitri Korotkevitch
      Pages 125-148
  3. Other things that matter

    1. Front Matter
      Pages 149-149
    2. Dmitri Korotkevitch
      Pages 151-163
    3. Dmitri Korotkevitch
      Pages 165-180
    4. Dmitri Korotkevitch
      Pages 181-193
    5. Dmitri Korotkevitch
      Pages 195-208
    6. XML
      Dmitri Korotkevitch
      Pages 209-232
    7. Dmitri Korotkevitch
      Pages 233-254
    8. CLR
      Dmitri Korotkevitch
      Pages 255-273
    9. Dmitri Korotkevitch
      Pages 275-300
    10. Dmitri Korotkevitch
      Pages 301-348
    11. Dmitri Korotkevitch
      Pages 349-372
  4. Locking, Blocking and Concurrency

    1. Front Matter
      Pages 1-1
    2. Dmitri Korotkevitch
      Pages 375-386
    3. Dmitri Korotkevitch
      Pages 387-397
    4. Dmitri Korotkevitch
      Pages 399-416
    5. Dmitri Korotkevitch
      Pages 417-425
    6. Dmitri Korotkevitch
      Pages 427-437
    7. Dmitri Korotkevitch
      Pages 439-442
    8. Dmitri Korotkevitch
      Pages 443-454
    9. Dmitri Korotkevitch
      Pages 455-457
  5. Query Life Cycle

    1. Front Matter
      Pages 459-459
    2. Dmitri Korotkevitch
      Pages 461-488
    3. Dmitri Korotkevitch
      Pages 489-519
  6. Practical Troubleshooting

    1. Front Matter
      Pages 521-521
    2. Dmitri Korotkevitch
      Pages 523-552
    3. Dmitri Korotkevitch
      Pages 553-582
  7. Inside the transaction log

    1. Front Matter
      Pages 583-583
    2. Dmitri Korotkevitch
      Pages 585-601
    3. Dmitri Korotkevitch
      Pages 603-624
    4. Dmitri Korotkevitch
      Pages 625-646
  8. In-Memory OLTP Engine

    1. Front Matter
      Pages 647-647
    2. Dmitri Korotkevitch
      Pages 649-688
  9. Columnstore Indexes

    1. Front Matter
      Pages 689-689
    2. Dmitri Korotkevitch
      Pages 691-707
    3. Dmitri Korotkevitch
      Pages 709-736
    4. Dmitri Korotkevitch
      Pages 737-753
  10. Back Matter
    Pages 755-769

About this book

Introduction

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 following:

  • Explains how to design efficient database schema, indexing, and transaction strategies.
  • Shows how various database objects and technologies are implemented internally and when they should or should not be used.
  • Demonstrates how SQL Server executes queries and works with data and transaction logs.

Bibliographic information