Buy Used
£2.80
FREE Delivery on orders over £10.
Used: Very Good | Details
Sold by the book house
Condition: Used: Very Good
Comment: This item will be picked, packed and shipped by Amazon and is eligible for free delivery within the UK
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Inside Microsoft® SQL ServerTM 2000 (DV-MPS Inside) Paperback – 18 Dec 2000

5.0 out of 5 stars 6 customer reviews

See all 3 formats and editions Hide other formats and editions
Amazon Price
New from Used from
Paperback
"Please retry"
£40.72 £0.01
click to open popover

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

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



Product details

  • Paperback: 1088 pages
  • Publisher: Microsoft Press; 3 edition (18 Dec. 2000)
  • Language: English
  • ISBN-10: 0735609985
  • ISBN-13: 978-0735609983
  • Product Dimensions: 18.8 x 5.3 x 24.5 cm
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (6 customer reviews)
  • Amazon Bestsellers Rank: 1,544,599 in Books (See Top 100 in Books)
  • See Complete Table of Contents

Product Description

Amazon Review

Inside Microsoft SQL Server 2000 has the details you need to design Microsoft database servers that will achieve the best possible performance. For one thing, author Kalen Delaney (who used Ron Soukoup'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 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.

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

From the Author

There’s no comparable source for up-to-date, authoritative SQL Server 2000 information—complete with extensive examples and practical advice.

See all Product Description

Customer Reviews

5.0 out of 5 stars
5 star
6
4 star
0
3 star
0
2 star
0
1 star
0
See all 6 customer reviews
Share your thoughts with other customers

Top Customer Reviews

Format: Paperback
Many SQL Server books give you the same information included already in Books Online. Perhaps with different words, or different order, but nothing completely new. Inside SQL Server 2000 is an excellent complement for Books Online, TechNet and MSDN. It covers similar topics, but it digs into the internal operations, explaining how SQL Server actually works, with unique information only available in this book.
I always want to know how things work internally, because it helps me to understand the behaviour of a system. In many cases, the published interface doesn't tell you exactly how the system work, and it could drive you to some misunderstandings. Here is where Inside SQL Server helps you. Kalen's unique access to the Dev team, she even has a desk in the same building as the dev team, gives her an unique position to write about the deepest features, and if you add her excellent teaching skills, you can get this unique result, where the hardest topics can be learned in an unusually easy way.
Chapter 3 "SQL Server Architecture" is a gem altogether. I couldn't do my work without it.
The "Internal Storage" section from Chapter 6 "Tables" is a classic, with renewed information for SQL Server 2000. As a SQL Server instructor, I don't see how I could teach without this information.
Chapter 8 "Indexes" has been modified a lot, to cover in a deeper detail the structure of SQL Server 2000 indexes. It helps you to understand why the Query Optimizer selects one specific query plan, and how SQL Server access data through indexes.
Chapter 9 "Modifying Data" is another special part of this book.
Read more ›
Comment 28 people found this helpful. 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
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 50 people found this helpful. 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
Format: Paperback
If you like the previous two "Inside" Books, or even if you just have them on your bookshelf for reference, then get this one too. Don't expect it to hand-hold you through the product, give real-world examples of product usage, tell you how to code your queries etc. That's not what the book is about - there are plenty of other books that cover these and other subjects well.
This book covers the internals of SQL 2000, how it works, how the optimiser does it's job, how the database pages are laid out - all the stuff you won't find documented anywhere else. This is the only book the SQL Server development team have put their first hand knowledge into, so if you're really interested in how the product works and is architected then buy this book (or get a job on the SQL Server development team).
Comment 11 people found this helpful. 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


Feedback