Page Free Space

Pulling Group By Above a Join One of the transformations available to the SQL Server query optimizer is pulling a logic...

Apply versus Nested Loops Join SQL is a declarative language. We use SQL to write a logical query specification that d...

Nested Loops Prefetching Nested loops join query plans can be a lot more interesting (and complicated) than is commonly...

Improving Partitioned Table Join Performance The query optimizer does not always choose an optimal strategy when joinin...

SQL Server Optimizer Bug with JOIN and GROUP BY I came across a SQL Server optimizer bug recently that made me wonder h...

Join Performance, Implicit Conversions, and Residuals Introduction You probably already know that it’...

Heaps of Trouble? Brad Schulz recently wrote about optimizing a query run against tables with no indexes at all . The...