SQL Server Blocking: What the Head Blocker Does Not Tell You
Explains SQL Server blocking chains, head blockers, and why transaction duration matters more than the session itself for diagnosing performance issues.
Explains SQL Server blocking chains, head blockers, and why transaction duration matters more than the session itself for diagnosing performance issues.
Explains blocking, covariate adjustment, and optimal design to improve statistical power in online experiments, with a Python implementation.
Analysis of a SQL Server blocking scenario where a failed update with missing permissions blocks an index rebuild, exploring lock incompatibility.