T-SQL Anti-Patterns: EAV

Yesterday's anti-pattern ended with me talking about performance.  The rest of my anti-patterns have to do primarily with performance.  The first entry in this category is the king of poorly-performing solutions:  the Entity-Attribute-Value model.  The single best presentation of the EAV model and its constituent failings is this one by Phil Factor.  What follows is…

Advertisement