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

Reducing Contention on the NESTING_TRANSACTION_FULL latch Each additional worker thread in a parallel execution plan ex...

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

Optimizing T-SQL queries that change data Most tuning efforts for data-changing operations concentrate on the SELECT s...