Microsoft® SQL Server® 2008 Internals (Pro - Developer) at Dominant Systems Book Store

Delve inside the core SQL Server engineand put that knowledge to workwith 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 changesand 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 trackingfrom 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 planor 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

Customer Reviews & Comments
If you're looking for a step-by-step kind of book about SQL Server 2008, look elsewhere. That is not the intent of this book. If you want to truly know what goes on under the hood of Microsoft's new powerhouse database, get this book now. I've ready every copy of Inside SQL Server from 6.5 through to 2000. And I mean every page. I've read Inside Microsoft SQL Server 2005: The Storage Engine from cover-to-cover as well. Here's the thing... each edition gets better and better. Subtle little clarifications here. A paragraph of extra information there. And now with SQL Server 2008 Internals you have one of the best guides to the innner workings of SQL Server you can get your hands on. I must reiterate: This is not a DBA's Guide. By that I mean that it is not filled with step-by-steps. Instead, it explains what's happening when you take those steps. For this reason, the book will not be for everyone; however, for those who are developing database applications based on SQL Server 2008, there's no better way to truly learn how the DB works and, therefore, optimize your application. Another great book in the series...

Back To Top