Think before Creating that Lookup Table...

An interesting article at SQLServerCentral on the so called all-in-one Lookup tables.

I agree 100% with the author. I have seen the kind of confusion that one of these table can create. Once people know that there is this thing, every type of code will start getting into it as people like to reuse exisiting facilities, instead of re-inventing the wheel (by creating a new table).

But in real life, I find almost every project lands up with atleast one of these tables.