Using SQL Server Plan Guides to Influence Query Execution
SQL Server plan guides allow you to use a particular optimization hint without changing the syntax of the SELECT statement. Learn how.
Read MoreMost Popular Databases
Use SQL Server Optimization Hints with Caution
SQL Server optimization hints are optional parts in a SELECT statement that instruct the query optimizer to execute one specific behavior. Learn when to use them and why to use with caution.
Read MoreAbout SQL Server 2012 Query Processing–Plan Caching
The part of memory the SQL Server Database Engine uses to store compiled query plans is called the plan cache. Learn several ways in which you can influence execution plans.
Read MoreSQL Server 2012 Query Processing–Join Order Selection
The join operation is the most time-consuming operation in SQL Server query processing. Learn more.
Read MoreAbout SQL Server 2012 Query Processing–Index Selection
In the index selection phase of query processing, the SQL Server optimizer checks each search argument to see if there are indices in relation to the corresponding expression. Learn more.
Read MoreAbout SQL Server 2012 Query Processing–Query Analysis
During query analysis, the SQL Server optimizer examines the query for search arguments, the use of the OR operator, and the existence of join criteria, in that order. Learn more.
Read MorePhases of SQL Server 2012 Query Processing
The SQL Server optimizer works out the most efficient execution plan for a given query through parsing, query compilation, query optimization and query execution. Learn more.
Read MoreAbout SQL Server 2012 Replication Models
SQL Server replication models are used by a company to design its own data replication. Learn more about the options.
Read MoreSQL Server 2012 Distributed Data and Methods for Distributing
In SQL Server, you can distribute data on multiple database servers through distributed transactions or data replication. Learn which method might be best for your environment.
Read MoreSQL Server 2012 High Availability and Disaster Recovery
SQL Server 2012 introduces high availability and disaster recovery (HADR), which allows you to maximize availability for your databases. Learn more.
Read MoreAbout SQL Server Parallel Processing of Tasks
The SQL Server Database Engine can execute different database tasks in parallel, including: bulk loads, backups, query execution, indices. Learn more.
Read MoreAbout SQL Server Row Versioning
The SQL Server Database Engine supports an optimistic concurrency control mechanism (versus pessimistic concurrency) based on row versioning. Learn more.
Read More