http://www.sqlservercentral.com/Content tagged Database Design, Naming Standards, Basics posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Most databases designs nowadays seem to have at least a few if not many lookup or reference tables. This article helps you define a strategy in how to design, approve, and deploy them. http://www.sqlservercentral.com/articles/Basics/lookupstrategy/921/2003/02/20http://www.sqlservercentral.com/articles/Basics/lookupstrategy/921/Identity columns are last years news. Have you experimented with uniqueindentifiers - better known to programmers as GUID's? Guaranteed to be unique in the world, they offer a powerful alternative to identity columns. http://www.sqlservercentral.com/articles/Basics/usinguniqueindentifierinsteadofidentity/439/2001/09/17http://www.sqlservercentral.com/articles/Basics/usinguniqueindentifierinsteadofidentity/439/