Microsoft SQL Server 2008 Internals

Microsoft SQL Server 2008 Internals

4.11 - 1251 ratings - Source

Delve inside the core SQL Server enginea€”and put that knowledge to worka€”with guidance from a team of well-known internals experts. Whether database developer, architect, or administrator, youa€™ll gain the deep knowledge you need to exploit key architectural changesa€”and capture the producta€™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 trackinga€”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 plana€”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 usersIndexes: Internals. and. Management. Kalen Delaney, with Kimberly L. Tripp and Paul S. Randal Microsoft SQL Server ... we focus on index internals and maintenance a€”expanding these topics to give you creation best practices and optimalanbsp;...

Title:Microsoft SQL Server 2008 Internals
Author: Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Publisher:Microsoft Press - 2009-03-11

You must register with us as either a Registered User before you can Download this Book. You'll be greeted by a simple sign-up page.

Once you have finished the sign-up process, you will be redirected to your download Book page.

How it works:
  • 1. Register a free 1 month Trial Account.
  • 2. Download as many books as you like (Personal use)
  • 3. Cancel the membership at any time if not satisfied.

Click button below to register and download Ebook
Privacy Policy | Contact | DMCA