Cover art for Microsoft SQL Server 2008 Internals
Published
Microsoft Press, April 2009
ISBN
9780735626249
Format
Softcover, 784 pages
Dimensions
23cm × 18.6cm × 4.3cm

Microsoft SQL Server 2008 Internals by

Not in stock
Fast $7.95 flat-rate shipping!
Only pay $7.95 per order within Australia, including end-to-end parcel tracking.
100% encrypted and secure
We adhere to industry best practice and never store credit card details.
Talk to real people
Contact us seven days a week – our staff are here to help.

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

Related books

  • Murach's MySQL by

    This practical, hands-on tutorial/reference/guide to MySQL is perfect for beginners, but it also works for experienced developers who aren't getting the most ...

    call for availability
  • Pig in Action Munging Big Data by

    DESCRIPTION Spring in Action, Fourth Edition continues the practical, hands-on style of the previous bestselling editions. Author Craig Walls has a special knack for crisp ...

    call for availability
  • Microsoft SQL Server 2008 T-SQL Fundamentals by

    Master the foundations of T-SQL with the right balance of conceptual and practical content. Get hands-on guidance-including exercises and code samples-that show you how to ...

    call for availability
  • PostgreSQL Up and Running by
    due for release
  • Pro SQL Server 2012 Extended Events by

    Pro SQL Server 2012 Extended Events gives you the edge in diagnosing and troubleshooting performance and other problems by providing visibility into the database engine ...

    call for availability
  • Murachs SQL Server 2012 for Developers by

    Every application developer who uses SQL Server 2012 should own this book. To start, it presents the essential SQL statements for retrieving and updating the ...

    call for availability