Pro SQL Server Internals

Nonfiction, Computers, Database Management, General Computing
Cover of the book Pro SQL Server Internals by Dmitri Korotkevitch, Apress
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Author: Dmitri Korotkevitch ISBN: 9781430259633
Publisher: Apress Publication: June 30, 2014
Imprint: Apress Language: English
Author: Dmitri Korotkevitch
ISBN: 9781430259633
Publisher: Apress
Publication: June 30, 2014
Imprint: Apress
Language: English

Pro SQL Server Internals explains how different SQL Server components work "under the hood" and how they communicate with each other. This is the practical book with a large number of examples that will show you how various design and implementation decisions affect the behavior and performance of your systems.

Pro SQL Server Internals covers a multiple SQL Server versions starting with SQL Server 2005 all the way up to the recently released SQL Server 2014. You’ll learn about new SQL Server 2014 features including the new Cardinality Estimator, In-Memory OLTP Engine (codename Hekaton), and Clustered Columnstore Indexes. With Pro SQL Server Internals, you have a solid roadmap for understanding the depth and power of the SQL Server database backend, regardless of the version and edition of SQL Server you use.

Pro SQL Server Internals does the following:

  • Explains how to design efficient database schema, indexing, and transaction strategies.
  • Shows how various database objects and technologies are implemented internally and when they should or should not be used.
  • Demonstrates how SQL Server executes queries and works with data and transaction logs.
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart

Pro SQL Server Internals explains how different SQL Server components work "under the hood" and how they communicate with each other. This is the practical book with a large number of examples that will show you how various design and implementation decisions affect the behavior and performance of your systems.

Pro SQL Server Internals covers a multiple SQL Server versions starting with SQL Server 2005 all the way up to the recently released SQL Server 2014. You’ll learn about new SQL Server 2014 features including the new Cardinality Estimator, In-Memory OLTP Engine (codename Hekaton), and Clustered Columnstore Indexes. With Pro SQL Server Internals, you have a solid roadmap for understanding the depth and power of the SQL Server database backend, regardless of the version and edition of SQL Server you use.

Pro SQL Server Internals does the following:

More books from Apress

Cover of the book 4G: Deployment Strategies and Operational Implications by Dmitri Korotkevitch
Cover of the book Beginning Backdrop CMS by Dmitri Korotkevitch
Cover of the book Neural Networks for Electronics Hobbyists by Dmitri Korotkevitch
Cover of the book How to Kill the Scrum Monster by Dmitri Korotkevitch
Cover of the book Introduction to DevOps with Chocolate, LEGO and Scrum Game by Dmitri Korotkevitch
Cover of the book Mastering Zoho CRM by Dmitri Korotkevitch
Cover of the book Learn Cocoa on the Mac by Dmitri Korotkevitch
Cover of the book Pro AngularJS by Dmitri Korotkevitch
Cover of the book Practical MongoDB by Dmitri Korotkevitch
Cover of the book Pro MERN Stack by Dmitri Korotkevitch
Cover of the book Programming LEGO® EV3 My Blocks by Dmitri Korotkevitch
Cover of the book Developing Professional iPhone Photography by Dmitri Korotkevitch
Cover of the book Oracle IaaS by Dmitri Korotkevitch
Cover of the book Pro Android UI by Dmitri Korotkevitch
Cover of the book Swift for Absolute Beginners by Dmitri Korotkevitch
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