Ok, I'll give my .02 worth. BS. What am I supposed to use as a PK? GUIDs? GUIDs are what M$ uses and they are a PITA. DavidB
-----Original Message----- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:48 AM To: CF-Talk Subject: SOT: DB Design I am working on a new DB design for a CFMX app and was doing a little refresher research on keys and data types and ran across this quote from former SQL Server project manager Ron Soukup, "Identity primary keys are for people who believe there's never time to design a table right but there's always time to do it over." In another related article, another MS SQL guy says that the only reason identity made it into SQL server was because of Access.... (not a direct quote). Anyone care to comment? Mike ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4