Automotive Holiday Deals Shop Men's Athletic Shoes Learn more nav_sap_SWP_6M_fly_beacon Black Friday egg_2015 All-New Amazon Fire TV Beauty Deals Gifts for Her Find the Best Purina Pro Plan for Your Pet Amazon Gift Card Offer cm15 cm15 cm15 $30 Off Amazon Echo $30 Off Fire HD 6 Kindle Cyber Monday Deals Entertainment Collectibles Outdoor Deals on DOTD

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.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your email address or mobile phone number.

Inside Microsoft SQL Server 2000

76 customer reviews
ISBN-13: 978-0735609983
ISBN-10: 0735609985
Why is ISBN important?
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Have one to sell? Sell on Amazon
Buy used
Condition: Used: Very Good
Comment: .
Access codes and supplements are not guaranteed with used items.
46 Used from $0.01
More Buying Choices
15 New from $19.64 46 Used from $0.01
Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student

Get Up to 80% Back Rent Textbooks

Special Offers and Product Promotions

  • Take an Extra 30% Off Any Book: Use promo code HOLIDAY30 at checkout to get an extra 30% off any book for a limited time. Excludes Kindle eBooks and Audible Audiobooks. Restrictions apply. Learn more | Shop now

Editorial Reviews 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.

About the Author

Over 60 SQL Server MVPs contributed to this book, which was assembled and edited by Kalen Delaney and SQL Server legends Louis Davidson (Database Design and Architecture), Greg Low (Business Intelligence.), Brad McGhee (Performance Tuning and Optimization), Paul Nielson (Database Development), and Paul Randal and Kimberly Tripp (Database Administration.)


Product Details

  • Paperback: 1088 pages
  • Publisher: Microsoft Press (December 15, 2000)
  • Language: English
  • ISBN-10: 0735609985
  • ISBN-13: 978-0735609983
  • Product Dimensions: 7.4 x 2.1 x 9.7 inches
  • Shipping Weight: 4.1 pounds
  • Average Customer Review: 3.4 out of 5 stars  See all reviews (76 customer reviews)
  • Amazon Best Sellers Rank: #2,440,576 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

43 of 45 people found the following review helpful By Itzik Ben-Gan on December 4, 2000
Format: Paperback
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.Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
24 of 25 people found the following review helpful By Karl Smith on February 27, 2001
Format: Paperback
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
43 of 49 people found the following review helpful By Robert Stepford on January 17, 2001
Format: Paperback
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
19 of 20 people found the following review helpful By Kevin Tsai on June 17, 2001
Format: Paperback
If you're looking to really understand the core engine of SQL Server and how to optimize your code, this is a really good book. If you're a database architect, this book may be a little too microscopic for you, lacking in design strategy. Surprisingly, I think this is actually a great book for the DBA - the discussions on the underlying mechanics are second to none.
This book is named very appropriately. The author does an excellent job detailing what goes on under the hood of SQL Server. As an example, she exposes the details of the Bulk Change Map pages in database files and how they work in relationship with the Bulk Logged recovery mode, new to SQL Server 2000. It's one thing to read and memorize what can and can't be accomplished in Bulk Logged recovery mode, but it's a totally different feeling being enlightened on why it works the way it works. There are many core principles in how SQL Server operates that the author describes in detail.
Here what I wished to have seen more coverage on: 1. Replication - this book does not cover replication. There are other books that show you how to point and click (I guess those point-and-click picture books will be called "Outside SQL Server 2000"), but none I've seen go into the "Inside" level. 2. Distributed Partitioned Views - This book shows how to create a distributed partitioned views, but it stops there. There are very important design considerations such as knowing where to place your data so as to minimize joins across the network. 3. Indexed Views - Same as distributed partitioned views - ends at the "how to create". I'd like to see how it works under the hood. 4. One way to classify this book is that it is very "server-centric". Many of us work on systems of database servers that work in concert under the application layer.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Recent Customer Reviews