Page Free Space

This article was originally published on 𝕏. Background Since SQL Server indexed views don’t allow MIN or MAX aggregates, I recently fo...

This article was originally published on 𝕏. Introduction Update execution plans are not something the T-SQL statement writer has much co...

Parallel Index Building Execution Plan SQL Server doesn't support parallel modifications to a b-tree index. That might sound surprising....

Allocation Order Scans When an execution plan includes a scan of a b-tree index structure, the storage engine may be ab...

Incorrect Results Caused By Adding an Index Say you have the following two tables, one partitioned and one not: CREATE...

Two Partitioning Peculiarities Table partitioning in SQL Server is essentially a way of making multiple physical tables...

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...

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

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 ...

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...

The Impact of Non-Updating Updates From time to time, I encounter a system design that always issues an UPDATE against...