id love to know the outcome of this one....since we use Identity PK's like they are going out of style :)
tony weeg uncertified advanced cold fusion developer tony at navtrak dot net www.navtrak.net office 410.548.2337 fax 410.860.2337 -----Original Message----- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:56 AM To: CF-Talk Subject: Re: DB Design I welcome the discussion but back it up.. PITA? In what ways? ----- Original Message ----- From: "Boardwine, David L." <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 29, 2003 10:50 AM Subject: RE: DB Design > 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
