- 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: 7.4 x 1.2 x 8.9 inches
- Shipping Weight: 2 pounds (View shipping rates and policies)
- Average Customer Review: 19 customer reviews
Amazon Best Sellers Rank:
#2,636,872 in Books (See Top 100 in Books)
- #316 in Books > Computers & Technology > Hardware & DIY > Microprocessors & System Design > Computer Design
- #615 in Books > Computers & Technology > Databases & Big Data > Data Warehousing
- #978 in Books > Computers & Technology > Networking & Cloud Computing > Data in the Enterprise > Client-Server Systems
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Inside Microsoft® SQL Server 2005: The Storage Engine (Developer Reference) 2005 ed. Edition
Use the Amazon App to scan ISBNs and compare prices.
This month's Book With Buzz: "The Lying Game" by Ruth Ware
From the instant New York Times bestselling author of blockbuster thrillers "In a Dark, Dark Wood" and "The Woman in Cabin 10" comes Ruth Ware’s chilling new novel, "The Lying Game." See more
Customers who bought this item also bought
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.
Browse award-winning titles. See more
Top customer reviews
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).
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.
NB. My only negative on this book is that it begins with 3 pages of acknowledgements listing technical colleagues, editors, friends etc that helped refine the book to what it is, but just within the first few pages there is an "xxx" placeholder in the text that hasn't been updated, a reference to a companion CD that was dropped from publication plus other technically incorrect statements. In fact, there are so many editorial errors throughout the book that there is a significant page on [...] dedicated to documenting the corrections. All books contain errors, but it was just painful to see so many after reading through the myriad of people that helped "perfect" this book. On a positive note, kudos to the author for acknowledging the problems and publishing the corrections.
I would describe the book like this:
You have a car and it is nice and pretty on the outside, and you can do all sorts of cool things with the buttons on the console and you can play music and other nifty things, such as GPS. Well, on the inside of the car you have no clue how it all ties together and what is going on when you push that button.
Well, imagine this book as a blueprint of how your car's innards work, down to the very last oil spot on the engine.
This book is the best down right down to the memory block detailed book I have seen on SQL 2005. Now, the hard part about this book is that it can be difficult to read, and follow, at times. There are several sections you may have to read over and over again just to start to understand what it even means.
If you are looking for a good hard core book on the SQL engine, this is it for you. I give this book a 5 star rating for content, author knowledge and sheer impressive information.