Page Free Space

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

Optimizer Limitations with Filtered Indexes One of the filtered index use cases mentioned in the product documentation ...

A creative use of IGNORE_DUP_KEY Let’s say you have a big table with a clustered primary key, and an application that i...

Avoiding Uniqueness for Performance In my last post, Enforcing Uniqueness for Performance , I showed how using a unique...

Enforcing Uniqueness for Performance A little while back, I posted a short series on seeks and scans: When is a Seek ...