Page Free Space

This article was originally published on 𝕏. Introduction Microsoft encourages us not to use the datetime data type: Avoid using date...

Why Doesn’t Partition Elimination Work? Given a partitioned table and a simple SELECT query that compares the partitio...

Dynamic Seeks and Hidden Implicit Conversions A LIKE predicate with only a trailing wildcard can usually use an index...

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