Articles

Page 8 of 10 — showing articles 127 to 144 of 177

Query Optimizer Deep Dive—Part 4

Deep Dive 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 1

Deep Dive 1

The SQL Server query optimization pipeline, early stages of compilation, and cardinality estimation. Includes trivial plans.

SQL Server, Seeks, and Binary Search

Game of Chance

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.