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 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
- Author
- Kalen Delaney, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Adam Machanic, Ben Nevarez, Paul Randal, Kimberly Tripp
- Format
- paperback
- Pages
- 786
- Publisher
- Microsoft Press
- Language
- english
- ISBN
- 9780735626249
- Genres
- technical, reference, technology, programming
- Release date
- 2009
- Search 9780735626249 on Amazon
- Search 9780735626249 on Goodreads