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 Designing Connected Content by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book Talking to Siri by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book Wireless Networking with Microsoft Windows Vista by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book Apple Pro Training Series by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book Research in the Decision Sciences for the Service Economy by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book The iPhone Developer's Cookbook by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book The Great Gatsby: York Notes for AS & A2 by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book How to Get the Best of Your Credit Cards by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book Learn Adobe Photoshop CC for Visual Communication by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book Charisma by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book Interface Design for Learning by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book The Definitive Guide to Inventory Management by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book The New Language of Business by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book Richard Templar's Rules by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book Becoming a Strategic Organization (Chapter 2 from Disrupt Together) 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