Skip to main content
SpringerLink
Log in
Download book PDF
Download book EPUB
Book cover
  • Book
  • © 2014

Pro SQL Server Internals

Apress

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.

Sections

Table of contents (35 chapters)

  1. Front Matter

    Pages i-xxxi
    PDF

  2. Tables and Indexes

    1. Front Matter

      Pages 1-1
      PDF

    2. Data Storage Internals

      • Dmitri Korotkevitch
      Pages 3-27
      PDF
    3. PDF

    4. Statistics

      • Dmitri Korotkevitch
      Pages 53-80
      PDF

    5. Special Indexing and Storage Features

      • Dmitri Korotkevitch
      Pages 81-112
      PDF

    6. Index Fragmentation

      • Dmitri Korotkevitch
      Pages 113-124
      PDF

    7. Designing and Tuning the Indexes

      • Dmitri Korotkevitch
      Pages 125-148
      PDF

  3. Other things that matter

    1. Front Matter

      Pages 149-149
      PDF

    2. Constraints

      • Dmitri Korotkevitch
      Pages 151-163
      PDF

    3. Triggers

      • Dmitri Korotkevitch
      Pages 165-180
      PDF

    4. Views

      • Dmitri Korotkevitch
      Pages 181-193
      PDF

    5. User-Defined Functions

      • Dmitri Korotkevitch
      Pages 195-208
      PDF

    6. XML

      • Dmitri Korotkevitch
      Pages 209-232
      PDF

    7. Temporary Tables

      • Dmitri Korotkevitch
      Pages 233-254
      PDF

    8. CLR

      • Dmitri Korotkevitch
      Pages 255-273
      PDF

    9. CLR Types

      • Dmitri Korotkevitch
      Pages 275-300
      PDF

    10. Data Partitioning

      • Dmitri Korotkevitch
      Pages 301-348
      PDF

    11. System Design Considerations

      • Dmitri Korotkevitch
      Pages 349-372
      PDF

  4. Locking, Blocking and Concurrency

    1. Front Matter

      Pages 1-1
      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.
Back to top

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.
Back to top

Bibliographic Information

Back to top

Publish with us

Policies and ethics

Back to top
Download book PDF
Download book EPUB

Search

Navigation