Skip to main content
SpringerLink
Log in
Apress
Book cover

Pro SQL Server Internals

  • Book
  • © 2014

Overview

Authors:
  1. Dmitri Korotkevitch
    View author publications

    You can also search for this author in PubMed   Google Scholar

  • Pro SQL Server Internals explains how SQL Server works focusing on how internal implementation affects your database operations.

This is a preview of subscription content, log in via an institution to check access.

Access this book

Log in via an institution
eBook USD 44.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever

Tax calculation will be finalised at checkout

Other ways to access

Licence this eBook for your library

Institutional subscriptions

Table of contents (35 chapters)

  1. Front Matter

    Pages i-xxxi
    Download chapter PDF

  2. Tables and Indexes

    1. Front Matter

      Pages 1-1
      Download chapter PDF

    2. Data Storage Internals

      • Dmitri Korotkevitch
      Pages 3-27

    3. Tables and Indexes: Internal Structure and Access Methods

      • Dmitri Korotkevitch
      Pages 29-52

    4. Statistics

      • Dmitri Korotkevitch
      Pages 53-80

    5. Special Indexing and Storage Features

      • Dmitri Korotkevitch
      Pages 81-112

    6. Index Fragmentation

      • Dmitri Korotkevitch
      Pages 113-124

    7. Designing and Tuning the Indexes

      • Dmitri Korotkevitch
      Pages 125-148

  3. Other things that matter

    1. Front Matter

      Pages 149-149
      Download chapter PDF

    2. Constraints

      • Dmitri Korotkevitch
      Pages 151-163

    3. Triggers

      • Dmitri Korotkevitch
      Pages 165-180

    4. Views

      • Dmitri Korotkevitch
      Pages 181-193

    5. User-Defined Functions

      • Dmitri Korotkevitch
      Pages 195-208

    6. XML

      • Dmitri Korotkevitch
      Pages 209-232

    7. Temporary Tables

      • Dmitri Korotkevitch
      Pages 233-254

    8. CLR

      • Dmitri Korotkevitch
      Pages 255-273

    9. CLR Types

      • Dmitri Korotkevitch
      Pages 275-300

    10. Data Partitioning

      • Dmitri Korotkevitch
      Pages 301-348

    11. System Design Considerations

      • Dmitri Korotkevitch
      Pages 349-372

  4. Locking, Blocking and Concurrency

    1. Front Matter

      Pages 1-1
      Download chapter PDF
Back to top

About this book

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.

About the author

Dmitri Korotkevitch is Microsoft SQL Server MVP and Microsoft Certified Master (in SQL Server 2008). He brings years of experience working with SQL Server as an Application and Database Developer, Database Administrator, and Database Architect. He specializes in design, development, and performance tuning of OLTP Systems working under heavy load.


Dmitri regularly speaks at various Microsoft and SQL PASS events, and he provides SQL Server training to clients around the world. He blogs at: http://aboutsqlserver.com.

Bibliographic Information

Publish with us

Policies and ethics

Back to top

Search

Navigation