Start reading Microsoft SQL Server 2008 Internals (Developer Reference) on your Kindle in under a minute. Don't have a Kindle? Get your Kindle here or start reading now with a free Kindle Reading App.

Deliver to your Kindle or other device


Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.
Microsoft SQL Server 2008 Internals (Developer Reference)

Microsoft SQL Server 2008 Internals (Developer Reference) [Kindle Edition]

Kalen Delaney , Adam Machanic , Paul S. Randal , Kimberly L. Tripp , Conor Cunningham , Ben Nevarez
4.8 out of 5 stars  See all reviews (6 customer reviews)

Print List Price: £37.54
Kindle Price: £22.31 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: £15.23 (41%)
* Unlike print books, digital books are subject to VAT.


Amazon Price New from Used from
Kindle Edition £22.31  
Paperback £29.95  
Kindle Daily Deal
Kindle Daily Deal: At least 60% off
Each day we unveil a new book deal at a specially discounted price--for that day only. Learn more about the Kindle Daily Deal or sign up for the Kindle Daily Deal Newsletter to receive free e-mail notifications about each day's deal.

Product Description

Product Description

Delve inside the core SQL Server engine—and put that knowledge to work—with guidance from a team of well-known internals experts. Whether database developer, architect, or administrator, you’ll gain the deep knowledge you need to exploit key architectural changes—and capture the product’s full potential. Discover how SQL Server works behind the scenes, including:

  • What happens internally when SQL Server builds, expands, shrinks, and moves databases
  • How to use event tracking—from triggers to the Extended Events Engine
  • Why the right indexes can drastically reduce your query execution time
  • How to transcend normal row-size limits with new storage capabilities
  • How the Query Optimizer operates
  • Multiple techniques for troubleshooting problematic query plans
  • When to force SQL Server to reuse a cached query plan—or create a new one
  • What SQL Server checks internally when running DBCC
  • How to choose among five isolation levels and two concurrency models when working with multiple concurrent users

About the Author

Kalen Delaney is a Microsoft MVP who has worked with SQL Server since 1987. She's a subject-matter expert on Microsoft's official SQL Server courses and previously wrote Inside SQL Server (Microsoft Press). She lives in the Pacific Northwest.

Paul Randal and wife Kimberly L. Tripp are two of the most-sought-after SQL Server speakers in the world. A Microsoft MVP and Regional Director, Paul is also contributing editor to TechNet Magazine.

Kimberly L. Tripp is a SQL Server MVP and a Microsoft Regional Director and has worked with SQL Server since 1990. She lectures for a variety of events including Microsoft Tech*Ed and is married to co-editor and SQL guru Paul Randal.

Conor Cunningham is principal architect of the SQL Server Core Engine Team at Microsoft.

Product details

  • Format: Kindle Edition
  • File Size: 4091 KB
  • Print Length: 784 pages
  • Simultaneous Device Usage: Up to 5 simultaneous devices, per publisher limits
  • Publisher: Microsoft Press; 1 edition (11 Mar 2009)
  • Sold by: Amazon Media EU S.à r.l.
  • Language: English
  • ASIN: B00JDMPQ78
  • Text-to-Speech: Enabled
  • X-Ray:
  • Average Customer Review: 4.8 out of 5 stars  See all reviews (6 customer reviews)
  • Amazon Bestsellers Rank: #704,368 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?

More About the Authors

Discover books, learn about writers, and more.

Customer Reviews

3 star
2 star
1 star
4.8 out of 5 stars
4.8 out of 5 stars
Most Helpful Customer Reviews
4 of 4 people found the following review helpful
5.0 out of 5 stars Chock full of SQL Server goodness.... 28 Sep 2009
Format:Paperback|Verified Purchase
This is the first Internals book I've ever read, and after a couple of chapters I am finding it to be an incredible learning journey. I've read the chapters that I felt were my strongest ground, yet with almost every sentence I've learnt something new. It's certainly not for newcomers to the SQL Server scene, and it's certainly not a How To - but for anyone who wants to understand what goes on underneath the hood in SQL Server, this is it!
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
4.0 out of 5 stars Useful but obscure 28 Aug 2010
By M. Sear
Format:Paperback|Verified Purchase
A very useful book if you want to deep dive - as the name implies it isnt for everyone. Some highly obscure things in the book - and I have had my moneys worth from it.
Comment | 
Was this review helpful to you?
5 of 7 people found the following review helpful
If SQL Server held court, then the authors of this book would all be part of the inner sanctum. I would buy a book by any of these authors, just on their names, so finding them all in on publication is really a no-brainer.

Anyone wishing to learn more about how the SQL Server engine works, rather than just learning by rote how to do things, should read this book to gain insight into the reasons why/how you do things. As such this book is not really for absolute beginners, but if you are a quick learner you will soon be able to appreciate parts of this book. The book goes to levels often skipped over by other publications.

Despite having multiple talented authors and deep technical content I found the book to come across in a consistent and enjoyable style, anyone serious about SQL Server should have this on their bookshelves.
Comment | 
Was this review helpful to you?
Would you like to see more reviews about this item?
Were these reviews helpful?   Let us know

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

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

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category