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...
Main Author: | |
---|---|
Format: | eBook |
Language: | English |
Published: |
Redmond, Wash.
Microsoft
2009
|
Subjects: | |
Online Access: | |
Collection: | O'Reilly - Collection details see MPG.ReNa |
Summary: | 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 |
---|---|
Item Description: | Master and use copy. Digital master created according to Benchmark for Faithful Digital Reproductions of Monographs and Serials, Version 1. Digital Library Federation, December 2002 |
Physical Description: | xxvi, 754 pages illustrations |
ISBN: | 9780735634787 0735638225 9780735636323 9780735626249 0735626243 073563632X 0735634785 |