New posts in Database Internals

Unclear update conflict

EXCEPT & INTERSECT: Purpose of Passive Projection in Logical Plan

Index Uniqueness Overhead

What is the purpose of this Uniq1002 column in this index scan?

Why is a temp table a more efficient solution to the Halloween Problem than an eager spool?

Why does an index rebuild requires a Sch-M lock?

In what cases are BLOB and TEXT stored in-line on InnoDB?

Making sense of sys.objects, sys.system_objects, and sys.sysobjects?

Why does the optimizer choose nested loops over merge joins here?

Contradiction detection