Advertisement

SQL Server Internals

  • Rob Walters
  • Grant Fritchey

Abstract

SQL Server 2012 is a powerful and complex database platform. The relational engine itself is composed of many subsystems. One of these is the command parser, which takes the input from the connection, validates it, and parses it into an internal structure called a query tree. Another is the Query Optimizer, which takes the query tree and prepares the statement for execution. These preparation tasks include ensuring the user executing the query has enough access to the underlying database objects within the query and optimizing the query with respect to performance. Query optimization is cost based, and SQL Server chooses the execution plan that is best for the given statement.

Keywords

Additional Data File Execution Plan Model Database Server Internal Query Tree 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Rob Walters, Grant Fritchey 2012

Authors and Affiliations

  • Rob Walters
  • Grant Fritchey

There are no affiliations available

Personalised recommendations