Page Free Space

Importing a File in Batches There are a million ways to import data into SQL Server. Most of the time, we want to inges...

A bug with Halloween Protection and the OUTPUT Clause Background The OUTPUT clause can be used to return results fro...

Halloween Protection – The Complete Series I have written a four-part series on the Halloween Problem . Some of you wi...

Incorrect Results with Indexed Views If you use MERGE , indexed views and foreign keys, your queries might return incor...

MERGE Bug with Filtered Indexes A MERGE statement can fail, and incorrectly report a unique key violation when: The ...

An Interesting MERGE Bug Investigating an optimizer transformation that exposes a bug in SQL Server’s MERGE implementa...