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

2 thoughts on “T-SQL Anti-Patterns

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s