T-SQL Anti-Patterns

This is a fourteen-part series on various anti-patterns that I have experienced as a database administrator.  It also forms the foundation for my SQL Saturday talk on the topic.

1. Introduction
2. ANSI-89 Joins
3. SELECT *
4. Zombie Fields
5. Unconstrained Data
6. Lack of Normalization
7. EAV
8. Nested Views
9. User-Defined Functions
10. Row-By-Agonizing Row (RBAR) Queries
11. Query-By-Agonizing-Query (QBAQ) Operations
12. Non-SARGable ORs In Joins
13. Linked Server Joins
14. Clustered GUIDs

Advertisements