Inside the Optimizer: Constructing a Plan - Part 4

The final part in a series by Paul White exploring the internals of query optimization. Learn how

Inside the Optimizer: Constructing a Plan - Part 3

Join Paul White in part three of a four-part series exploring the internals of query optimization as he looks at the rules that are used to build the execution plan.

Inside the Optimizer: Constructing a Plan - Part 2

How does the query optimizer build an execution plan for your queries? Paul White shows is in part two of a four-part series exploring the internals of query optimization.

Inside the Optimizer: Constructing a Plan - Part 1

Part one of a four-part series exploring the internals of query optimization from T-SQL guru, Paul White.

Optimising Server-Side Paging - Part II

The second part of this series compares four methods of obtaining the total number of rows in a paged data set.

A round number

Optimising Server-Side Paging - Part I

This article by Paul White presents an optimisation for paging through a wide data set.

ANSI_NULLS