Page Free Space

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

SQL Server, Seeks, and Binary Search The following table summarizes the results from my last two articles, Enforcing Un...

Seeking Without Indexes A seek can contain one or more seek predicates , each of which can either identify (at most) on...

So…is it a Seek or a Scan? You might be most familiar with the terms ‘Seek’ and ‘Scan’ from the graphical plans produce...

When is a Seek not a Seek? The following script creates a single-column clustered table containing the integers from 1 ...

A Tale of Two Index Hints If you look up Table Hints in the official documentation, you’ll find the following stateme...