Programming Books C Java PHP Python Learn more Browse Programming Books

Sorry, this item is not available in
Image not available for
Image not available

To view this video download Flash Player


Sign in to turn on 1-Click ordering
More Buying Choices
Have one to sell? Sell yours here
Tell the Publisher!
I'd like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Inside Microsoft® SQL Server™ 2005: The Storage Engine (Developer Reference) [Paperback]

Kalen Delaney
4.4 out of 5 stars  See all reviews (18 customer reviews)

Buy New
$37.46 & FREE Shipping. Details
Usually ships within 1 to 4 weeks.
Ships from and sold by Gift-wrap available.
Free Two-Day Shipping for College Students with Amazon Student


Amazon Price New from Used from
Kindle Edition --  
Paperback, Bargain Price $19.59  
Paperback, October 18, 2006 $37.46  
Shop the new
New! Introducing the, a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Book Description

October 18, 2006 0735621055 978-0735621053 2005 ed.

Take an in-depth look at the internals of the SQL Server Storage Engine—with advice from a popular author and SQL Server expert. Database developers and administrators get best practices, pragmatic advice, and code samples to help master the intricacies of creating and maintaining enterprise relational databases.

Discover how to:

Upgrade or migrate to SQL Server 2005 and choose configuration options Control space allocation for databases and files manually or automatically Manage transaction logs to maximize efficient restore operations and data consistency Observe the internal structures of clustered and nonclustered indexes Build and partition relational indexes and tables Explore internal storage issues and compare fixed- and variable-length datatypes Detect and correct index fragmentation Implement and manage an appropriate concurrency model using locking or row versioning

    PLUS—Get code samples on the Web.

Frequently Bought Together

Inside Microsoft® SQL Server™ 2005: The Storage Engine (Developer Reference) + Inside Microsoft SQL Server 2005: T-SQL Querying (Developer Reference)
Price for both: $68.76

One of these items ships sooner than the other.

Buy the selected items together

Editorial Reviews

From the Author

Key Book Benefits:

- Delivers practical, hands-on guidance for understanding and making the most of the architecture of SQL Server storage, including logging and recovery, indexes, tables, transactions and locking, and security - Provides deep background information that helps developers better understand how to build more responsive databases that have fewer vulnerabilities - Features numerous code samples, table examples, practical advice, and best practices

About the Author

Kalen Delaney, a Microsoft MVP for SQL Server since 1993, provides advanced SQL Server training to clients worldwide. She is a contributing editor and columnist for SQL Server Magazine and the author of several highly regarded books, including Microsoft SQL Server 2008 Internals.

Product Details

  • Series: Developer Reference
  • Paperback: 464 pages
  • Publisher: Microsoft Press; 2005 ed. edition (October 18, 2006)
  • Language: English
  • ISBN-10: 0735621055
  • ISBN-13: 978-0735621053
  • Product Dimensions: 1.2 x 7.2 x 8.8 inches
  • Shipping Weight: 2 pounds (View shipping rates and policies)
  • Average Customer Review: 4.4 out of 5 stars  See all reviews (18 customer reviews)
  • Amazon Best Sellers Rank: #1,297,252 in Books (See Top 100 in Books)

More About the Author

Kalen Delaney has been working with SQL Server since 1987 when she joined the Sybase Corporation in Berkeley, California. Kalen has an independent international trainer and consultant since 1992. As a consultant, she has worked with both Microsoft Corporation and Sybase Corporation to develop courses and provide internal training for their technical support staff. Kalen has taught Microsoft Official Curriculum courses, as well as her own independently developed Advanced SQL Server Internals courses, to clients around the world. In addition, she has been writing regularly about SQL Server since 1995. Kalen is also a contributing editor and columnist for SQL Server Magazine and has been a SQL Server Most Valuable Professional since 1995.

Customer Reviews

Most Helpful Customer Reviews
9 of 9 people found the following review helpful
5.0 out of 5 stars Excellent Information Source April 18, 2007
Most SQL Server DBA's I know who have been working on SQL Server 7 or 2000 for any length of time usually have a copy of Kalen Delaney's "Inside SQL Server" sitting on their desk. For SQL Server 2005, that book has been split into four different books and it looks like all them are going to be must-have's occupying large swaths of book-shelf space across the planet. Because, the fact of the matter is, if you want to know the internals of the new database engine, this is your source.

Comparisons between this new book and the previous books in the series seem inevitable. From that type of comparison, I think that this book comes off very well. Removing the TSQL processing and other aspects of development from the book allows Delaney to drill down into every aspect of how the server works. She takes a very structured approach, showing how to install SQL Server before moving on to the Server Architecture and Configuration chapters. She covers database and database files, logging and recovery, tables, indexes, and locking, each in separate chapters, each in a great degree of detail. She takes the time between explaining how things work to suggest best practices for configuration and usage along the way. Scattered throughout are also Tip's & Notes that suggest alternatives to the topic under discussion or implications of the usage of a particular topic.

This is not a book from which you can easily learn basic SQL Server skills. So much time is spent on so much detail, invaluable detail for the experienced user, that the novice might get stuck in the mire. I personally don't find that to be an actual detraction from the book.
Read more ›
Comment | 
Was this review helpful to you?
8 of 8 people found the following review helpful
4.0 out of 5 stars Technically advanced but sometimes incomprehensible October 2, 2007
Format:Paperback|Verified Purchase
This book is perhaps the best book out there for understanding SQL 2005 architecture. I know of no other book which offers such advanced understanding of how SQL 2005 stores, retrives, and manages data.

Indeed, the author is a MS SQL MVP and has written with the collaboration of those who wrote the code for MS SQL 2005 at Microsoft.

The author's explaination, however, could be a lot better. For example, here is an exerpt on the author's explaination of IAM (Index Allocation Map):

"An IAM page contains a page header; an IAM page header, which contains eight page pointer slots; and a set of bits that map a range of extents on a file, which doesn't neccessarily have to be the same file that IAM page is in. The header has address of first extent in the range mapped by the IAM. The eight page pointer slots might contain pointers to pages belonging to the relevant object contained in mixed extents; only the first IAM for an object has values in these pointers."

Now, I have worked with databases for over a decade and have good understanding of Indexes and its structure, and I still did not understand what the author was talking about on some sentences.

1)Explains data and index storage structures (Page, extents, B-Tree, Keys etc) and how they are managed in transactions (update, delete, insert) better than any book I know.
2)Relatively short book (400 pages) which does not waste words or sentences to make it a thicker book (common practice to write a thicker book for a higher price).

1)Tries to combine MS SQL 101 topics (What is Master, MSDB, TEMP, and MODEL db?) with expert subject matter (What is IAM, Cluster Keys, RID, etc).
2)Writing is sometimes indecipherable.
3)Mostly not for the beginners (despite its rudimentrary coverage of the basics).
Was this review helpful to you?
5 of 5 people found the following review helpful
5.0 out of 5 stars Depth and Clarity February 22, 2007
Format:Paperback|Verified Purchase
I'm stingy with reviews, but once again, Kalen's book is a winner and this is one of the few great books on SQL Server. Her writing style is clear and she gets right to the details. Every book serves a specific need. If you need to understand the SQL Server engine, then this is the best book for that purpose. I have thoroughly enjoyed reading this book. Thanks, Kalen!
Comment | 
Was this review helpful to you?
6 of 7 people found the following review helpful
3.0 out of 5 stars This is a great series February 22, 2007
By Stephen
This is a good book, I did learn a few new things to help me better understand SQL Server 2005. However, I strongly recommend the T-SQL Querying book of this series over this one. Though the titles suggest different coverage, my opinion is that the T-SQL Querying book gave much better insight in the physical structure of indexes. Though the book was not that bad, it did not provide the detailed coverage of 'storage engine' topics I had expected.
Comment | 
Was this review helpful to you?
3 of 3 people found the following review helpful
5.0 out of 5 stars A valuable addition to the 'Inside SQL' series August 1, 2007
Format:Paperback|Verified Purchase
I've been following this series since the days of Ron Soukup, and Delaney once again does not fail to deliver and impress in this latest edition.

This book is part of a four part volume set (the 4th still awaiting publication at the time of this review), which previous to this release was contained in one volume. This shows how much more information is being published on SQL Server 2005, and gives Delaney the opportunity to focus on select topics and go into far more detail when covering them.

This book contains a perfect balance of material appropriate for the topics being discussed: (configuring SQL Server, logical table and log structures, internal file structures and management, the many available locking mechanisms). For topics not relevant to content of this book, Delaney frequently refers to the other books within this series and in particular the book on query tuning and optimization she is still working on.

Having now read a few volumes on SQL 2005, I can confidently state that Delaney does not waste pages regurgitating material that's either unrelated or unnecessary to the topic being discussed, but instead I found her insights and knowledge transfer unique to this book and worth the time learning.

Overall, I would highly recommend this book to anyone seriously wanting to learn SQL Server 2005 at a higher than basic level. You will not be disappointed.

Read more ›
Comment | 
Was this review helpful to you?
Most Recent Customer Reviews
5.0 out of 5 stars Me gustó mucho el libro. Siempre bien la editorial.
I've always liked and preferred publisher Microsoft, especially on issues that are of domain ownership. Its content seems appropriate and well treated the subject matter. Read more
Published 16 days ago by PABLO ZURITA CACERES
5.0 out of 5 stars Inside Microsoft SQL SERVER 2005: The Storage Engine
This is a well written book that contains plenty of insight into how SQL Server works.
Published on May 3, 2009 by Jose Tigeleiro
5.0 out of 5 stars Not a fast read, but worth the investment
First note: this book is not a page turner. It is not dry, but packed. It will take a long time to get through, but the book is worth the effort if you are trying to get some... Read more
Published on April 2, 2009 by Christopher Brandsma
5.0 out of 5 stars Best SQL Server internals book on the market
This is NOT a book to learn about SQL Server programming. This is for the advanced student of database programming or optimization. Read more
Published on August 7, 2008 by Jason Short
1.0 out of 5 stars Less signal more noise
I have attempted to read this book atleast 4 times in the last year. A couple of times I tried reading cover to cover. Other times I jumped into specific chapters. Read more
Published on August 5, 2008 by Dheepa Ramani
5.0 out of 5 stars Fantastic
Okay, reviewing this book is going to be quite difficult. I have mixed feelings however everything that I have to say about this book is positive. Read more
Published on January 5, 2008 by Jason
5.0 out of 5 stars Very Informative
Great book. Very informative and in depth, especially if you are looking for not only logical database structure but actual physical information. Read more
Published on June 29, 2007 by M. Galaviz
5.0 out of 5 stars Great book - what's not to like?
I read one of the reviews that said that they didn't like the book, thought it wasn't organized well - bah. Read more
Published on March 22, 2007 by Scott D. Whigham
5.0 out of 5 stars Deep info, many valueable information
I read the book and found it is well written and contains lots of information. May be some not need it, but to be good SQL Server DBA I think it is necessary to understand internal... Read more
Published on March 18, 2007 by Andrey Smirnov
Search Customer Reviews
Search these reviews only

What Other Items Do Customers Buy After Viewing This Item?


Search Customer Discussions
Search all Amazon discussions

Start a new discussion
First post:
Prompts for sign-in

Look for Similar Items by Category