Microsoft SQL Server 2008 Internals

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 po [...]
Visa längre beskrivning

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 databasesHow to use event tracking--from triggers to the Extended Events EngineWhy the right indexes can drastically reduce your query execution timeHow to transcend normal row-size limits with new storage capabilitiesHow the Query Optimizer operatesMultiple techniques for troubleshooting problematic query plansWhen to force SQL Server to reuse a cached query plan--or create a new oneWhat SQL Server checks internally when running DBCCHow to choose among five isolation levels and two concurrency models when working with multiple concurrent users