Section
6 pages
Anti-Patterns
Database patterns that look fine in review and fail in production, with the measured failure: non-SARGable predicates, polymorphic references, covering-index traps, cross-database joins.
Collation Drift: The Silent Index Killer
0
Cross Database Joins: The Coupling You Can't See Until You Split
0
God Tables: 150 Columns and the Quiet Cost of 'Just Add a Column'
0
Non Sargable Predicates: How a Function in Where Kills Your Index
0
One Column Added to a Select: 1,020 Page Reads Became 166,667
0
Random Uuids as Primary Keys: The B Tree Penalty
0