Join Amazon Prime and get unlimited Free One-Day Delivery. Already a member? Sign in.

 

or
Sign in to turn on 1-Click ordering.
 
   
More Buying Choices
36 used & new from £1.82
Have one to sell? Sell yours here
 
   
Inside Microsoft® SQL Server™ 2000 (DV-MPS Inside)
 
 
Share your own customer images
Search inside this book

Inside Microsoft® SQL Server™ 2000 (DV-MPS Inside) (Paperback)

by Kalen Delaney (Author) "In 1985, Microsoft and IBM announced "a long-term joint development agreement for development of operating systems and other systems software products ..." (more)
5.0 out of 5 stars See all reviews (6 customer reviews)
RRP: £48.20
Price: £30.99 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save: £17.21 (36%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In stock.
Dispatched from and sold by Amazon.co.uk. Gift-wrap available.

Only 1 left in stock--order soon (more on the way).

Want guaranteed delivery by Tuesday, July 21? Choose Express delivery at checkout. See Details
14 new from £25.00 22 used from £1.82

Frequently Bought Together

Customers buy this book with Advanced Transact-SQL for SQL Server 2000 by Itzik; Moreau, Tom Ben-Gan

Inside Microsoft® SQL Server™ 2000 (DV-MPS Inside) + Advanced Transact-SQL for SQL Server 2000
Price For Both: £76.11

One of these items ships sooner than the other. Show details

  • This item: Inside Microsoft® SQL Server™ 2000 (DV-MPS Inside) by Kalen Delaney

    In stock.
    Dispatched from and sold by Amazon.co.uk.
    This item Delivered FREE in the UK with Super Saver Delivery. See details and conditions

  • Advanced Transact-SQL for SQL Server 2000 by Itzik; Moreau, Tom Ben-Gan

    Usually dispatched within 1 to 3 weeks.
    Dispatched from and sold by Amazon.co.uk.
    This item Delivered FREE in the UK with Super Saver Delivery. See details and conditions

Customers Who Bought This Item Also Bought

SQL Server 2000 Administrator's Pocket Consultant (IT-Administrator's Pocket Consultant)

SQL Server 2000 Administrator's Pocket Consultant (IT-Administrator's Pocket Consultant)

by William Stanek
4.7 out of 5 stars (3) 
Inside Microsoft® SQL Server™ 2005: The Storage Engine (Solid Quality Learning)

Inside Microsoft® SQL Server™ 2005: The Storage Engine (Solid Quality Learning)

by Kalen Delaney (Solid Quality Learning)
4.7 out of 5 stars (3)  £24.84
Advanced Transact-SQL for SQL Server 2000

Advanced Transact-SQL for SQL Server 2000

by Itzik; Moreau, Tom Ben-Gan
4.4 out of 5 stars (7)  £45.12
Inside Microsoft® SQL Server™ 2005: T-SQL Programming (Solid Quality Learning)

Inside Microsoft® SQL Server™ 2005: T-SQL Programming (Solid Quality Learning)

by Dejan Sarka; Roger Wolter Itzik Ben-Gan (Solid Quality Learning)
5.0 out of 5 stars (2)  £23.07
Inside Microsoft® SQL Server™ 2005: Query Tuning and Optimization

Inside Microsoft® SQL Server™ 2005: Query Tuning and Optimization

by S. Agarwal, C. Freedman, A. Machanic, R. Talmage Kalen Delaney
4.0 out of 5 stars (1)  £25.67
› Explore similar items

Product details

  • Paperback: 1088 pages
  • Publisher: MICROSOFT PRESS; 2nd Revised edition edition (1 Nov 2000)
  • Language English
  • ISBN-10: 0735609985
  • ISBN-13: 978-0735609983
  • Product Dimensions: 23.8 x 19 x 5.6 cm
  • Average Customer Review: 5.0 out of 5 stars See all reviews (6 customer reviews)
  • Amazon.co.uk Sales Rank: 271,071 in Books (See Bestsellers in Books)

    Popular in these categories:

    #60 in  Books > Computing & Internet > Databases > SQL
    #100 in  Books > Computing & Internet > Databases > Applications > Microsoft SQL Server

    •  Would you like to update product info or give feedback on images?

  • See Complete Table of Contents

Customers Viewing This Page May Be Interested in These Sponsored Links

  (What is this?)
Dell - Server Offers
   www.Dell.com/uk    High Performance Dell Servers With Intel® Xeon®. Hurry & Get Yours! 
SQL Server 2005 + 5 CALs
   www.tekgia.com/SQL_Standard_2005    Only £399 + VAT for Churches, Schools, Councils and Charities 
SQL 2008 Standard £718
   www.eCostSoftware.com    Buy Full UK Retail Box Software. Up to 20% Off. Same Day shipment ! 
  
 

Product Description

Amazon.co.uk 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

Product Description
Master the inner workings of today’s premier relational database management system with this official guide to the SQL Server™ 2000 engine. Written by a renowned columnist in partnership with the product development team, this is the must-read book for anyone who needs to understand how SQL Server internal structures affect application development and functionality. Its extensive details about the latest product enhancements, updated installation and administration, and its development advice can help you create high-performance data-warehousing, transaction-processing, and decision-support applications that will scale up for any challenge. Topics covered include: • Evolution, architecture, and toolset: The history of SQL Server since 1989, an architectural overview, and a comprehensive tour of its tools and features • Planning and deployment: Everything you need to know about installation and deployment issues such as multiple instances, Super Sockets, and upgrades • Databases, files, tables, and data: How to create, modify, back up, and restore databases, files, and tables; and how to query and modify data • Built-in development tools: Using Query Analyzer and SQL Server Profiler to simplify system administration and optimize performance; programming with Transact-SQL; and extending functionality with batches, transactions, stored procedures, and triggers • Query-processing techniques: Multiple indexes, hash and merge joins, and data-manipulation capabilities such as parallel queries • Internal architecture: Low-level details of data and index-page structures, locking mechanisms, optimization, and plan caching • Integration with other tools: Usage with Microsoft® Office 2000, Visual Studio® development system, and the BackOffice® server family INCLUDED ON TWO CD-ROMS! • A 120-day evaluation copy of Microsoft SQL Server 2000 Enterprise Edition • A searchable electronic copy of the book • Sample scripts • White papers and articles • Tools and utilities 

See all Product Description

Inside This Book (Learn More)
First Sentence
In 1985, Microsoft and IBM announced "a long-term joint development agreement for development of operating systems and other systems software products. Read the first page
Explore More
Concordance
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Suggested Tags from Similar Products

 (What's this?)
Be the first one to add a relevant tag (keyword that's strongly related to this product)
Check a corresponding box or enter your own tags in the field below
dba
sql2000
sql server
kalen delaney
inside microsoft sql server 2000 with cd...

Your tags: Add your first tag
 
See most popular tags

What Do Customers Ultimately Buy After Viewing This Item?

Inside Microsoft® SQL Server™ 2000 (DV-MPS Inside)
88% buy the item featured on this page:
Inside Microsoft® SQL Server™ 2000 (DV-MPS Inside) 5.0 out of 5 stars (6)
£30.99
Professional SQL Server 2000 Programming (Programmer to Programmer)
12% buy
Professional SQL Server 2000 Programming (Programmer to Programmer) 5.0 out of 5 stars (10)
£34.49
Explore similar items
 

Customer Reviews

6 Reviews
5 star:
 (6)
4 star:    (0)
3 star:    (0)
2 star:    (0)
1 star:    (0)
 
 
 
 
 
Average Customer Review
5.0 out of 5 stars (6 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

 
27 of 27 people found the following review helpful:
5.0 out of 5 stars It always goes with me. It is the Bible of SQL Server 2000, 24 Dec 2000
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. If you want to know how page split works, how SQL deletes, updates and insert rows, and you want to see what actually happens inside the data page, this is your chapter, as it is "my" chapter.

However, the best part of this book, in my opinion, is the last part: "Performance and Tuning". You can argue that this is not a section for every database administrator or programmer, but if any SQL Server professional wants to convert a database system into an excellent system, this section is a must. Kalen has been involved in the creation of the excellent SQL Server Performance Tuning courses for versions 6.5 (MOC 665) and 7.0 (MOC 2013) and this section covers in great detail all the main topics a serious SQL Server professional should know.

If you are new to SQL Server, buy another book first, and learn as much as possible. Once you think you know everything about it, buy Inside SQL Server, and you will see how much you still have to learn.

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
50 of 51 people found the following review helpful:
5.0 out of 5 stars The bible of SQL Server 2000, 1 April 2001
By A Customer
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.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
11 of 11 people found the following review helpful:
5.0 out of 5 stars Latest in a great series, 27 Dec 2000
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 Comment | Permalink | Was this review helpful to you? Yes No (Report this)


Share your thoughts with other customers: Create your own review
 
 
 
Most Recent Customer Reviews

5.0 out of 5 stars Great insight
This book is not intended as a how-to book for database administrators. Instead, it explains what is going on "under the bonnet" so that you have a better understanding of what... Read more
Published on 22 Dec 2004 by Graham Phillips

5.0 out of 5 stars Probably the best SQL Server 2000 Book
I'm not joking either. Spending time on usergroups as I do THIS is the book that all other books are compared too. Read more
Published on 4 Jun 2004 by igorthehunchback

5.0 out of 5 stars Will help you install / migrate large SQL databases
A recent company re-structure has meant that I have picked up the responsibility for the whole of one of our databases (rather than merely the accuracy of the information which... Read more
Published on 8 Aug 2002 by nickromney

Only search this product's reviews


Customer Discussions

 Beta (What's this?)
This product's forum (0 discussions)
  Discussion Replies Latest Post
  No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
  [Cancel]

   

Listmania!

Create a Listmania! list

Look for similar items by category

Feedback

Microsoft SQL Server 2000...

Microsoft SQL Server...

Learn from a SQL Server performance authority how to make your... Read more
£41.80

›Find similar items

 

More From Kalen Delaney

Microsoft® SQL Server...

Microsoft® SQL Server® 2008 Internals

Explore the definitive guide to the internals and architecture of the... Read more
£47.49 £20.99

 

Boys Smell

Lynx Africa Body Spray and After Shave Gift set
But we make sure they smell good...

›Discover male grooming at Amazon.co.uk

  

Treat Someone

Amazon.co.uk Gift Certificates--available in any amount from £5 to £500 With an Amazon.co.uk Gift Certificate, you can get them what they want (even if you don't know what that is).

›Learn more about Gift Certificates

  
Ad

Where's My Stuff?

Delivery and Returns

Need Help?

Your Recent History

  (What's this?)
You have no recently viewed items or searches.

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.

Look to the right column to find helpful suggestions for your shopping session.
Continue Shopping: Top Sellers

amazon.co.uk Amazon Home
International Sites:  United States  |  Germany  |  France  |  Japan  |  Canada  |  China
Business Programs: Sell on Amazon  |  Fulfilment by Amazon  |  Join Associates  |  Join Advantage
Customer Service  |  Help  |  View Basket  |  Your Account
About Amazon.co.uk  |  Careers at Amazon
Conditions of Use & Sale |  Privacy Notice  © 1996-2009, Amazon.com, Inc. and its affiliates