Star Wars Sale

Special Offers see all

Enter to WIN!

Weekly drawing for $100 credit. Subscribe to for a chance to win.
Privacy Policy

More at Powell's

Recently Viewed clear list

Original Essays | June 20, 2014

Lisa Howorth: IMG So Many Books, So Many Writers

I'm not a bookseller, but I'm married to one, and Square Books is a family. And we all know about families and how hard it is to disassociate... Continue »
  1. $18.20 Sale Hardcover add to wish list

    Flying Shoes

    Lisa Howorth 9781620403013

Qualifying orders ship free.
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
1 Beaverton Database- SQL
2 Burnside - Bldg. 2 Database- Applications
2 Remote Warehouse Computers Reference- General
1 Remote Warehouse Computers Reference- General

Microsoft SQL Server 2012 Internals


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

Delaney, Kalen
Microsoft Press
Beauchemin, Bob
Randal, Paul S.
Nevarez, Benjamin
Cunningham, Conor
Kehayias, Jonathan
Computers-Reference - General
SQL Server;databases;query optimizer;storage engine
Database Management - General
Edition Description:
Trade Paper
Developer Reference
Publication Date:
9 x 7.38 in

Related Subjects

Business » High Tech Management
Children's » Historical Fiction » General
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 New Trade Paper
0 stars - 0 reviews
$61.99 In Stock
Product details 982 pages Microsoft Press - English 9780735658561 Reviews:
  • 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