Categories
7 pages
Query-Performance
Covering Index Traps: When Adding One Column Breaks Your Query
Non-SARGable Predicates: How a Function in WHERE Kills Your Index
Database Deadlocks, Part 2: Diagnosis, Retries, and Prevention
Database Deadlocks, Part 1: The Patterns
NULL in SQL: Three-Valued Logic and the Silent Bug Factory
Joins That Lie: The Cardinality Problem
Uniqueness and Selectivity: The Two Numbers That Drive Query Plans