Why Doesn’t Partition Elimination Work?
SQL Server can fail to eliminate partitions from a query due to implicit type conversion.
Articles
Page 8 of 10
— showing articles
127 to
144
of 179
Compute Scalars, Expressions and Execution Plan Performance
How the SQL Server Compute Scalar operator works internally.
Deletes that Split Pages and Forwarded Ghosts
Slow SQL Server DELETE peformance caused by unexpected page splitting or forwarded ghost records.
Temporary Table Caching Explained
Internal details of SQL Server temporary table and table variable caching.
Temporary Table Caching in Stored Procedures
How SQL Server temporary table caching can affect statistics, execution plans, and recompilations in unexpected ways.
Parallel Execution Plans Suck
Why TOP may not work well with SQL Server parallel queries.
Query Optimizer Deep Dive—Part 4
Internal operation of the SQL Server query optimizer. Writing queries that will take advantage of the optimizer's relational reasoning.
Query Optimizer Deep Dive—Part 3
SQL Server query optimizer memo structure, search stages, and final plan selection.
Query Optimizer Deep Dive—Part 2
Cost-based optimization in the SQL Server query optimizer, the input tree, properties, and rules.
Query Optimizer Deep Dive—Part 1
The SQL Server query optimization pipeline, early stages of compilation, and cardinality estimation. Includes trivial plans.
Fun with Scalar and Vector Aggregates
The important differences between SQL Server aggregates with a GROUP BY clause (vector) and those without (scalar aggregates).
Dynamic Seeks and Hidden Implicit Conversions
Dynamic seek plans driven by Constant Scan and Merge Interval operators.
Forcing a Parallel Query Execution Plan
How to force SQL Server to generate a parallel execution plan, including some of the reasons the server sometimes chooses a serial plan.
SQL Server Optimizer Bug with JOIN and GROUP BY
A SQL Server bug in cardinality estimation with serial partial aggregates. Covers how SQL Server uses local and partial aggregates.
Is Distinct Aggregation Still Considered Harmful?
Query rewrites to efficiently perform a DISTINCT aggregate using other aggregates. The SQL Server 2012 optimizer transformation that performs the rewrite for you.
Finding the Statistics Used to Compile an Execution Plan
Finding the statistics used to compile a SQL Server query using undocumented trace flags.
Can a SELECT query cause page splits?
Page splits caused by populating an Index Spool. EXECSYNC waits when loading a parallel spool.
SQL Server, Seeks, and Binary Search
SQL Server b-tree seeks can use binary search or linear interpolation (with linear regression). The latter can be more efficient, except when key values are separated by a small fixed gap.