Inside Microsoft SQL Server 2000 (Paperback)

~ (Author) "In 1985, Microsoft and IBM announced "a long-term joint development agreement for development of operating systems and other systems software products..." (more)
Key Phrases: Query Analyzer, Server Enterprise Manager, Server Agent (more...)

Editorial Reviews

Amazon.com Review

To help you design Microsoft database servers that must achieve the best possible performance, Inside Microsoft SQL Server 2000 has the details you need. For one thing, author Kalen Delaney (who used Ron Soukup's fantastic first edition as a starting point) explains how SQL Server 2000 works at a level that will interest all database administrators. She packs in the sort of minutiae that can make a real difference in the performance of especially large or complex data-storage structures, explaining what goes on inside the database management system (DBMS) when it's presented with various commands, and using that information to back up her abundant advice on the right way to design, build, and operate databases under SQL Server 2000.

Delaney makes extensive use of DBCC PAGE dumps to show what's going on in the databases that demonstrate concepts (incidentally, that utility is documented, as well as the others in the DBCC toolbox). In a typical section, DBCC PAGE is used to show how index pages work. There's careful attention to database structure at the byte level too, with conceptual diagrams that explain how pointers work and how strings of strings of bytes combine to represent stored data. It's the sort of detail you need if you'll be writing software for SQL Server 2000, or need to extract maximum performance from the DBMS itself. --David Wall

Topics covered: Microsoft SQL Server 2000 internals, especially data structures and the behavior of queries. Table design is emphasized, especially indexing decisions. Transact-SQL programming, including the use of cursors, gets lots of attention.

Product Description

This newly updated, official guide to the core architecture and internals of Microsoft SQL Server 2000 helps readers unlock the full power of Microsoft's premier relational database management system. Written by a renowned SQL Server guru, in conjunction with the Microsoft SQL Server 2000 product development team, INSIDE MICROSOFT SQL SERVER 2000 is a must-read for developers and IT professionals who need to understand Microsoft SQL Server from the inside out. This comprehensive guide provides updated, authoritative advice for installing, administering, and programming with SQL Server 2000. It also includes information about significant product enhancements, and new chapters about SQL Server Indexes and Query Optimization. The CD contains product evaluation documentation, sample code and scripts, white papers, and a benchmarking kit.

Product Details

• Paperback: 1088 pages
• Publisher: Microsoft Press (December 15, 2000)
• Language: English
• ISBN-10: 0735609985
• ISBN-13: 978-0735609983
• Product Dimensions: 9.4 x 7.5 x 2.2 inches
• Shipping Weight: 4.1 pounds (View shipping rates and policies)
• Average Customer Review: 3.4 out of 5 stars  See all reviews (74 customer reviews)
• Amazon.com Sales Rank: #611,728 in Books (See Bestsellers in Books)

Customer Reviews

Most Helpful Customer Reviews

43 of 45 people found the following review helpful:

5.0 out of 5 stars The bible of SQL Server 2000, December 4, 2000

By	Itzik Ben-Gan (Hi-Tech College, ISRAEL) - See all my reviews

Before Inside SQL Server 2000 came out, my favorite technical book on earth was Inside SQL Server 7. Up until today, there was no other book that I consulted with as much as I did with Inside 7. My copy is already in a very bad shape from overuse. I often consult with it whenever I am in doubt on any issue concerning SQL Server internals. I sometimes read from it to my students in class to prove a point. I had many expectations from inside SQL Server 2000 and I eagerly read every word in it. The book exceeded my expectations! Before it came out, I thought that it would have the same level of detail that Inside 7 had with additional discussions on SQL Server 2000s new features, but it goes far beyond that. In many areas it goes into smaller details than Inside 7 did discussing issues that I have never seen discussed in any other book or published document. For example, in the chapter about indexes DBCC PAGE is used extensively to actually traverse the B-Trees and examine the actual layout of the data in the index pages. By examining those, a lot of the points concerning the interesting index architecture that SQL Server uses become clearer. By getting to this level of detail, I feel that I have more adequate tools to make the right critical decisions in a system regarding which columns to index; on which column(s) to create the clustered index; space consumption of indexes on huge tables, and so on. The chapter also covers the new indexes on views and on computed columns. The chapter on locking discusses the locking architecture and the lock manager in detail but it also discusses internal lock structures such as Lock Blocks and Lock Owner Blocks in great depth. There is simply no way to get that information in any other source. Many internals related areas get more attention in Inside 2000 such as the storage engine and the relational engine. The query processor has a whole chapter of its own! The installation process is covered in great detail covering all the installation options, some of which are totally new, such as multi instances. It also covers hardware considerations such as RAID controllers, file system, memory and so on. The chapter on tables discusses internal page and row structures explaining every bit inside the row. T-SQL is not neglected either. Beyond programmatic aspects, Inside 2000 gets into the various internals and optimization aspects of the various constructs and handles query and performance tuning in depth. Among the topics that are covered are joins, subqueries, derived tables, user defined functions, stored procedures, transactions, referential integrity including the new cascading referential constraints, after and instead of triggers, views, cursors, large objects and more. Full-Text searching has a whole new section. Tough areas such as plan caching; auto parameterization and reuse of execution plans are also explained in detail. Join algorithms including nested loops, hash and merge are also explained. The coverage of data modification internals is outstanding! It includes coverage of page splits; the various internal update mechanisms such as in-place and non in-place updates; bulk inserts optimization and more. All these were just examples. The book is very rich in the areas that it covers and it is definitely a must for programmers and DBAs that really want to know their stuff as far as SQL Server is concerned. The book is a work of art.

24 of 25 people found the following review helpful:

3.0 out of 5 stars Decent book, SQL Server 2000 coverage lacking, February 28, 2001

By	Karl Smith (Boise, ID) - See all my reviews

This book is the same decent book the version 7 book was. That's really the problem -- they're too similar. As some of the other reviews have pointed out, you won't find coverage of XML in this book. Should you expect to? Well, I guess that's debatable. Me, I expected it and was really disappointed when I couldn't find anything on it at all. That said, there's still useful info here. Most of the internals between 7.0 and 2K didn't change much, so the book still applies. Some of the same errors that existed in the 7.0 book are still here, but, mostly, the book gets it right. I guess the final verdict is: if you already own the 7.0 book, don't waste your money. If you don't have the 7.0 book, this book is probably worth reading through.

43 of 49 people found the following review helpful:

3.0 out of 5 stars OK, but could be a lot better, January 17, 2001

By	Robert Stepford "bobstepford11" (New York) - See all my reviews

I read the previous version of this book and thought it was pretty good. It was a valuable resource when I was learning all I could about SQL Server for the first time. As I said in my review of that book, I felt the book belonged on every SQL Server DBA's bookshelf.

This book repeats much more of the version 7 book than I'd like. If it didn't claim to be a SQL Server 2000 book, I suppose that would be OK. To me the 2000 book should have a lot more 2000 specific stuff than it does. It really seems like this is just the version 7 book with a few additions. For example, I would like to have seen info on how the releases differ, but so far I haven't found it. I would like to have seen info on SQL Server's new XML support, but it's not there.... This doesn't mean that the book isn't useful or that the info is bad, just that it doesn't reach its full potential.

The conclusion I came to on this book is simply that the book is still pretty good, but could have been so much better

Bob S.