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 Trading Secrets by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book Business Express: Inspire your team to change by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book VMware VI and vSphere SDK by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book Global IPv6 Strategies by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book Disrupt Together by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book Solaris 10 System Administration Exam Prep by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book The Java Tutorial by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book Introduction to Game Design, Prototyping, and Development by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book Law Express: International Law by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book Influence by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book Adobe Flash CS3 Professional How-Tos by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book Designing Together by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book Law Express Question and Answer: Family Law by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book Microsoft Windows Server 2003 Delta Guide by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book Is It Safe? Protecting Your Computer, Your Business, and Yourself Online 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