- 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 (View shipping rates and policies)
- Average Customer Review: 75 customer reviews
- Amazon Best Sellers Rank: #2,819,992 in Books (See Top 100 in Books)
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
Use the Amazon App to scan ISBNs and compare prices.
The Amazon Book Review
Author interviews, book reviews, editors picks, and more. Read it now
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.)
Top customer reviews
My main qualm with this book is it seems to be hastily written. It reads almost like a late night term paper. This is not to say the information is inaccurate, but the writing of this book is second rate and the author's lack of enthusiasm for explaining the finer points is evident.
Delaney shows everything from how data is actually stored on disc to the internals of the query optimizer. I find her writing style to be smooth and easy to digest, and I had no problem reading this book cover-to-cover.
It will tell you about data tables, indexes, constraints, locking, stored procedures, transactions, T-SQL language, cursors, full text indexes, deadlocks, query hints and so on. It won't tell you anything about how any of these are used in practice. Even the "Performance and Tuning" section wouldn't give a lot of practical advises.
Anyhow, this book is a great reading, if you are a experienced database developer, and by chance want to know
* how the data is stored inside the tables and indexes
* how the index pages are scanned when searching for data
* how memory manager handles its buffers
* how to read the SQL Server performance counters
* how a database is backed up and restored
* how different isolation levels affect locking
* how transactions can be shared between different connections
* how stored procedured, user-defined functions and triggers work
* how different types of cursors lock the records they traverse
* how to make your full text indexes work efficiently
* how to safely use text and image data
and so on. Do NOT read it, if you want to know
* how a particular table should be organized
* what indexes needs to be created in your case
* what's the right backup policy and how to set it up
* how to write any particular program in T-SQL
* anything with numbers in it, ex. performance evaluation
because it's not there. The book is about SQL Server internals. It's not a manual, not by any chance. It's on the theoretical side if you like. Upon reading this book I have actually said to myself "Hey, I know how it works ! I can tell !". Still I will have to answer different questions and come up with specific decisions in any of my future applications.
Although much of the information explained in this book I have already read somewhere else, this one book is worth many others. Why ? Because it's deep and extensive. Every topic is covered to its depth. This is probably the reason why this book has a mixed feeling to it after all. It feels like the amount of information the author had to cope with was so overwhelming that she had no time to add a plot to it.
Still, highly recommended reading for any SQL Server developer.
If you want to understand if you should upgrade your existing SQL servers to SQL 2000, whether SQL 2000 will meet the requirements for your next project, this book is of use. In parts it is technical but it is also readable.
It describes how Microsoft SQL works and why it is the product it is to day. It covers general background that is simply not covered in other books. It covers it in a practical way that also reflects the theoretical point of view. I especially like the references to the ANSI SQL standards.
There is a section that talks about planning for an SQL database that goes into practical reasons why one RAID system is better than another but also when the cheaper solution is likely to be acceptable. It also mentions the reasons why you need to backup and restore your database even if you are using RAID.
Basically one puts data into a database and one allows queries of that data. Some data queries are simple, some are much more complex. End users "All I want is a list of names" know what they want but often have difficulties with syntax, NULL values and outer joins. There is discussion of the value of NULL and lots of examples of joins including outer joins. How to protect your users from outer joins yet still use the power of them. By the way if you are an end user who wants to query data Chapter 7 is all about querying data although you may need a programmer or DBA to help set up some of the more complex queries. Joins are much enhanced in this version by the way and may provide a business reason why you should upgrade.
Chapter 10 talks about the full text searching available in SQL 2000, using Microsoft Search Service including a discussion on maintaining full-text indexes and weights for complex searches and the reasons why the results from one installation may differ from another. These searches can be quite specialised so the examples that come on the CD are useful to demonstrate some of the techniques. It should be noted that the full text searching does use a stop word or noise list and there is a short discussion of the word-breaking algorithm used.
Chapter 11 talks about the use of batches, this is a technique promoted by Microsoft to minimise traffic on the network often a production bottleneck even on a LAN and very much so on a WAN or Internet connection. Real world performance gains of ten-fold to the client are not uncommon.
Chapter 16 gives common sense advice about query tuning. If you are an end user this is quite a good introduction to database tuning and how good systems are built. Again parts are technical but the concepts are there including why you may wish to duplicate the database for data warehousing type and other decision support queries.
In summary this book is not essential to use SQL 2000 but it will assist many in getting the most benefit from the product.