Nonficionado Sale
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Visit our stores


    Recently Viewed clear list


    Original Essays | May 5, 2015

    Leonard Mlodinow: IMG The Fragility of Grand Discoveries



    When I was in graduate school at Berkeley I was offered a prestigious fellowship to study for a year in Germany, but I decided it would be a... Continue »
    1. $19.57 Sale Hardcover add to wish list

    spacer
Qualifying orders ship free.
$43.00
List price: $61.99
Used Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
1 Local Warehouse Database- SQL

More copies of this ISBN

Microsoft SQL Server 2012 Internals

by

Microsoft SQL Server 2012 Internals Cover

 

Synopses & Reviews

Publisher Comments:

Dive deep inside the architecture of SQL Server 2012

Explore the core engine of Microsoft SQL Server 2012—and put that practical knowledge to work. Led by a team of SQL Server experts, you’ll learn the skills you need to exploit key architectural features. Go behind the scenes to understand internal operations for creating, expanding, shrinking, and moving databases—whether you’re a database developer, architect, or administrator.

Discover how to:

  • Dig into SQL Server 2012 architecture and configuration
  • Use the right recovery model and control transaction logging
  • Reduce query execution time through proper index design
  • Track events, from triggers to the Extended Event Engine
  • Examine internal structures with database console commands
  • Transcend row-size limitations with special storage capabilities
  • Choose the right transaction isolation level and concurrency model
  • Take control over query plan caching and reuse

About the Author

Kalen Delaney, a Microsoft MVP for SQL Server since 1993, provides advanced SQL Server training to clients worldwide. She is a contributing editor and columnist for SQL Server Magazine and the author of several highly regarded books, including Microsoft SQL Server 2008 Internals.

Table of Contents

IntroductionChapter 1: SQL Server 2012 architecture and configurationChapter 2: The SQLOSChapter 3: Databases and database filesChapter 4: Special databasesChapter 5: Logging and recoveryChapter 6: Table storageChapter 7: Indexes: internals and managementChapter 8: Special storageChapter 9: Special indexesChapter 10: Query executionChapter 11: The Query OptimizerChapter 12: Plan caching and recompilationChapter 13: Transactions and concurrencyChapter 14: DBCC internalsAbout the authors

Product Details

ISBN:
9780735658561
Author:
Delaney, Kalen
Publisher:
Microsoft Press
Author:
Cunningham, Conor
Author:
Freeman, Craig
Author:
Kehayias, Jonathan
Author:
Beauchemin, Bob
Author:
Randal, Paul S.
Author:
Nevarez, Benjamin
Subject:
Computers-Reference - General
Subject:
SQL Server;databases;query optimizer;storage engine
Subject:
Database Management - General
Copyright:
Edition Description:
Trade Paper
Series:
Developer Reference
Publication Date:
20131131
Binding:
TRADE PAPER
Language:
English
Pages:
982
Dimensions:
9 x 7.38 in

Related Subjects

Business » High Tech Management
Children's » Historical Fiction » General
Computers and Internet » Computer Languages » SQL
Computers and Internet » Computers Reference » General
Computers and Internet » Database » Applications
Computers and Internet » Database » SQL
Computers and Internet » Internet » Information
History and Social Science » Linguistics » Specific Languages and Groups
History and Social Science » Politics » United States » Politics
Reference » Words Phrases and Language
Science and Mathematics » Environmental Studies » General

Microsoft SQL Server 2012 Internals Used Trade Paper
0 stars - 0 reviews
$43.00 In Stock
Product details 982 pages Microsoft Press - English 9780735658561 Reviews:
spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.