- 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)
- #237 in Books > Computers & Internet > Computer Science > Databases > SQL
- #555 in Books > Computers & Internet > Software & Graphics > Internet Applications > Web-server Software > Microsoft
- #688 in Books > Computers & Internet > Computer Science > Databases > Data Storage & Management > Data Mining
- See Complete Table of Contents
Inside Microsoft® SQL ServerTM 2000 (DV-MPS Inside) Paperback – 18 Dec 2000
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.
To get the free app, enter your mobile phone number.
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
Theres no comparable source for up-to-date, authoritative SQL Server 2000 informationcomplete with extensive examples and practical advice.See all Product Description
Top Customer Reviews
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 ›
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).
Most Recent Customer Reviews
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 you... Read morePublished on 22 Dec. 2004 by Graham Phillips
I'm not joking either. Spending time on usergroups as I do THIS is the book that all other books are compared too. Read morePublished on 4 Jun. 2004 by igorthehunchback
Look for similar items by category
- Books > Computing & Internet > Computer Science > Information Systems
- Books > Computing & Internet > Databases > Applications
- Books > Computing & Internet > Databases > Data Storage & Management > Data Mining
- Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
- Books > Computing & Internet > Databases > SQL
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
- Books > Computing & Internet > Web Development > Web-server Software > Microsoft