3 Key Performance Features of SQL Server 2014
SQL Server and database experts share insights on features of SQL Server 2014 that promise significant performance potential.
Read MoreMost Popular Query Optimizer
How the SQL Server Database Engine Affects Performance
The SQL Server Database Engine affects system performance primarily via the query optimizer and locks. Learn more.
Read MoreUse 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–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 MoreSQL Server Plan Caching and Recompilation–Parameterization
When SQL Server Query Optimizer comes up with a plan, it caches the plan using parametrization options to ensure it can be reused as widely as possible.
Read More