Articles

Page 2 of 10 — showing articles 19 to 36 of 177

The Adaptive Join Threshold

Threshold Problems

How an adaptive join decides to use a batch mode hash join or row mode apply. Includes details of the threshold calculation.

How Parallel Plans Start Up—Part 1

Start 1

The role of the parent task (coordinator) in preparing a plan for parallel execution. Includes initializing each operator and adding hidden profilers to collect runtime performance data such as row count and elapsed time.

SQL Server batch text hash and the sql_handle

Getting a Handle on Batch Text

Describes the structure of a sql_handle and explains how the SQL Server batch text hash component is calculated. Provides T-SQL functions to replicate the calculations.

Closest Match with Sort Rewinds

Closely Matched with Rewinds

A SQL Server sort operator can replay its results, but only when the sort operates on at most one row. This article employs a sort to avoid a table spool in a query designed to find the closest match to a given value in a second table.

When Do SQL Server Sorts Rewind?

Re-e-wind

The rare circumstances when a SQL Server sort operator inside a nested loop can rewind (replay) cached results to avoid re-executing child plan operators.