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

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

Industry Sectors
Pharma
Chemical Manufacturing
Biotechnology
Electronics
Telecommunications
Consumer Packaged Goods
Energy, Utilities & Environment