T-SQL Anti-Patterns: Unconstrained Data

In the previous T-SQL anti-pattern, I discussed zombie fields.  One of the reasons to avoid zombie fields (aside from the risk of infection) is that you typically don't get appropriate data constraints on your zombified attributes.  Today's anti-pattern is the generalization of this problem. Suppose you had a set of tables that looked like this:…

Advertisement

The theory of gaming: Call of Cthulhu: The Card Game

Publisher: Fantasy Flight Games Type of game: Collectible card game Number of players: 2 Learning curve: Medium Estimated time to play (first time/subsequent times): 1 hour and a half/1 hour Estimated setup time: 15 minutes (Note: I'm debating using pictures in this series; I'm deciding against it for right now, since you can always Google for them,…