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 Inclusive Leadership: The Definitive Guide to Developing and Executing an Impactful Diversity and Inclusion Strategy by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book Strategies for Real-Time System Specification by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book Picture Perfect Practice: A Self-Training Guide to Mastering the Challenges of Taking World-Class Photographs 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 Mastering Investment Banking Securities by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book Why You Need Smart Enough Systems (Digital Short Cut) by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book The 86 Percent Solution by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book ActionScript 3.0 Game Programming University by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book Sams Teach Yourself SQL in One Hour a Day by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book 100 Things Every Presenter Needs to Know About People by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book Inspire! by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book TCP/IP Illustrated, Volume 2 by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book Modeling Techniques in Predictive Analytics by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book My Pinterest by Kalen Delaney, Adam Machanic, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Ben Nevarez
Cover of the book Crowdsourcing Can Be Your Business Momentum Builder 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