Microsoft SQL Server 2008 Internals, Paperback



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


  • Format: Paperback
  • Pages: 784 pages, black & white illustrations
  • Publisher: Microsoft Press,U.S.
  • Publication Date:
  • Category: SQL Server / MS SQL
  • ISBN: 9780735626249



Free delivery within the UK
Standard Delivery
Within the UK

Also by Kalen Delaney



Available with free
standard delivery



Available with free
standard delivery