Lookup table advice from Joe Celko

No votes yet

Lookup tables or Entiry-Attribute-Value (EAV) tables are often used in SQL programming. Joe as always gives some great advice on how to properly design these kind of tables. http://www.simple-talk.com/sql/t-sql-programming/avoiding-the-eav-of-destruction/ His use of a view to prevent SQL engine from intent locking is a great idea that is new to me, I will have to remember that one.