Microsoft SQL Server 2008 Internals

Nonfiction, Computers, Database Management
Cover of the book Microsoft SQL Server 2008 Internals by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez, Pearson Education
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Author: Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez ISBN: 9780735638228
Publisher: Pearson Education Publication: March 11, 2009
Imprint: Microsoft Press Language: English
Author: Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
ISBN: 9780735638228
Publisher: Pearson Education
Publication: March 11, 2009
Imprint: Microsoft Press
Language: English

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
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart

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:

More books from Pearson Education

Cover of the book Unreal Engine 4 for Design Visualization by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book Turning Learning Right Side Up by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book Adobe InDesign CS4 How-Tos by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book Compensation and Benefit Design by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book The Money Tree by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book My iPad (covers iOS 7 for iPad 2, iPad 3rd/4th generation and iPad mini) by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book The Photoshop Workbook by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book Learning iPad Programming by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book The Definitive Guide to Modern Supply Chain Management (Collection) by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book Apple Training Series by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book Wuthering Heights: York Notes for A-level by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book It Takes a Genome by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book QuarkXPress 7 for Windows and Macintosh by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book Unleashing Microsoft Windows Vista Media Center by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book Interactive Project Management: Pixels, People, and Process by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
We use our own "cookies" and third party cookies to improve services and to see statistical information. By using this website, you agree to our Privacy Policy