Binding: Paperback Dewey Decimal Number: 005 EAN: 9780735621053 ISBN: 0735621055 Label: Microsoft Press Manufacturer: Microsoft Press Number Of Items: 1 Number Of Pages: 464 Publication Date: November 08, 2006 Publisher: Microsoft Press Sales Rank: 48668 Studio: Microsoft Press
Product DescriptionThis practical, hands-on book offers deep, thorough coverage of the internals of architecture and resource management in SQL Server 2005, focusing on the Storage Engine. The book features extensive code samples and table examples.
Customer Reviews
Average Rating:
Rating: - 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. Did you ever want to know how SQL Server writes the indexes to disk? How many bytes does that row actually take in memory? Those are the types of questions you can ask in this book and get incredibly detailed answers.
The section on index creation alone is fantastic. You will not find this level of detail in college books on database design and thoery. ... Read More
Rating: - 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. Neither approach worked for me.
I realized the reason is that the book's presentation is very confusing (atleast for me). There are a lot of contents in the book that can be found easily. For example chapter 6 starts with a primer on relational database which is not the goal of the book. Also I found the complete catalog of data ... Read More
Rating: - 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. For one, this is not for the faint of heart of casual reading. This book is there for those who want to learn the gory details of how SQL 2005 works.
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 ... Read More
Rating: - Technically advanced but sometimes incomprehensible
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 collaboration of those who have 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): ... Read More
Rating: - A valuable addition to the 'Inside SQL' series
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.
Read More
- Best SQL Server internals book on the market
- Less signal more noise
- Technically advanced but sometimes incomprehensible
