My new database design:

Create table TheUltimateGenericSolution(

Key int not null identity primary key,

Stuff text) -- Put in what you like in XML format

We don’t need any other tables - Now that’s generic!

As ridiculous as my solution is, strangely it benefits from all the advantages mentioned by the guy who wrote this article:

1.We can store integer values to most of the data and have the description stored in the "GenericLookUp" table. As we know that performance is always going to be better when we deal with numeric columns than non numeric columns.

2.Easy maintainabilty. Lets say we have 20 LookUp tables in a application. With this "GenericLookUp" table, we just need 3 stored pros(Insert/Update/Delete) to maintain the data.

3.Centralized information in one place. This table would be almost like a data dictionary.

Just show’s you how daft his arguments are!