
Category: SQL Server Database Engine


The new “metadata-only column changes” feature in SQL Server 2016 is useless!

Troubleshooting Long-Running SHRINK Operations

Are you using Linked Servers? They may be in serious danger!

T-SQL Tuesday #118 – I wish SQL Server had better Table Partitioning

The LOOP, HASH and MERGE Join Types

The "IGNORE_DUP_KEY" option in Primary Keys and Unique Indexes

The Curious Case of… Collations and Performance in SQL Server
