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 email address or mobile phone number.
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.
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.)
I used it somewhat, but ended up doing internet searches which were quicker. The help disk was a nice feature.Published on August 22, 2013 by Richard G Travaglini
Of the parts of the book that I've read, I felt that the book gets into the internals of SQL Server as would be expected. Read morePublished on December 8, 2008 by SK
This book is about SQL Server as of query and data access engine, not as of a whole product. It in fact covers the architecture of the SQL Server and its internals related to... Read morePublished on September 5, 2006 by Dmitry Dvoinikov
The best book I've seen. I've been working on SQL Server since 1997. Great for a technically inclined DBA or developer.Published on July 20, 2006 by R. Cherkasskiy
I attended one of the seminars of the author and was thoroughly impressed by her knowledge on the matter and decided to buy her book. I am very pleased that I decided to do that. Read morePublished on September 26, 2005 by Brian Kingsley
I've been scouring this book and found that the there is well written overview of SQL, much like a whitepaper. Read morePublished on March 31, 2005 by Joaquin Menchaca
What I love about this book is that it really shows you the full story of SQL Server, starting with a broad history of the product, and eventually delving down into the deep... Read morePublished on December 8, 2004 by Daniel Williams
I have been working with SQL Server for the last five years and about two years ago when I was in a dilemma about transactions I purchased this book. Read morePublished on July 1, 2004 by Khalil Virji