Microsoft Sql Server 2008 Internals

Microsoft Sql Server 2008 Internals

3.1 8
by Kalen Delaney, Paul Randal, Kimberly Tripp, Conor Cunningham
     
 

View All Available Formats & Editions

Delve inside the core SQL Server engine—and put that knowledge to work—with guidance from a team of well-known internals experts. Whether database developer, architect, or administrator, you’ll gain the deep knowledge you need to exploit key architectural changes—and capture the product’s full potential. Discover how SQL Server works

Overview

Delve inside the core SQL Server engine—and put that knowledge to work—with guidance from a team of well-known internals experts. Whether database developer, architect, or administrator, you’ll gain the deep knowledge you need to exploit key architectural changes—and capture the product’s full potential. Discover how SQL Server works behind the scenes, including:

  • What happens internally when SQL Server builds, expands, shrinks, and moves databases
  • How to use event tracking—from triggers to the Extended Events Engine
  • Why the right indexes can drastically reduce your query execution time
  • How to transcend normal row-size limits with new storage capabilities
  • How the Query Optimizer operates
  • Multiple techniques for troubleshooting problematic query plans
  • When to force SQL Server to reuse a cached query plan—or create a new one
  • What SQL Server checks internally when running DBCC
  • How to choose among five isolation levels and two concurrency models when working with multiple concurrent users

Product Details

ISBN-13:
9780735626249
Publisher:
Microsoft Press
Publication date:
03/18/2009
Pages:
786
Product dimensions:
7.30(w) x 8.90(h) x 6.60(d)

Related Subjects

Meet the Author

Conor Cunningham is principal architect of the SQL Server Core Engine Team at Microsoft.

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >

Microsoft SQL Server 2008 Internals 3.1 out of 5 based on 0 ratings. 8 reviews.
Anonymous More than 1 year ago
Anonymous More than 1 year ago
Anonymous More than 1 year ago
Anonymous More than 1 year ago
RickMartinez More than 1 year ago
If you want to be an expert in sql server performance this is the book for you! SQL Server Internals provides detailed information on the way that SQL Server processes your queries and manages your data. It starts with an overview of the architecture of the SQL SERVER relational database system and then continues looking at aspects of query processing and data storage. My favorite chapter is the twelfth chapter it covers the details of reading query plans. I have met Ben Nevarez in many of his presentations; he is very knowledgeable when it comes to sql server. I just started reading about Adam Mechanic and I just started using his stored procedures for performance. Ben has worked with SQL Server since 6.5! I think that is cool. This book is for anyone who wants a deep understanding of what SQL Server does behind the scenes. I would expect that you have some experience with both SQL SERVER and with T-SQL, you don't have to be an expert. Enjoy!
Anonymous More than 1 year ago
Anonymous More than 1 year ago
Anonymous More than 1 year ago