Look-up Tables in SQL

Posted on SQL Server Central See other posts from SQL Server Central
Published on Fri, 04 Mar 2011 07:00:00 UT Indexed on 2011/03/04 7:30 UTC
Read the original article Hit count: 254

Filed under:
Lookup tables can be a force for good in a relational database. Whereas the 'One True Lookup Table' remains a classic of bad database design, an auxiliary table that holds static data, and is used to lookup values, still has powerful magic. Joe Celko explains....
SQL Monitor NEW! SQL Monitor 2.0
Monitor SQL Server Central's servers with
Red Gate's new SQL Monitor.
No installation required. Find out more.

© SQL Server Central or respective owner