I'm not entirely sure what they may have been getting at, but I assume they are referring to the cap on the number of records you can have using identities. That said, it all depends on the size of your app and the potential number of records you may have in a table. If you're not looking at storing millions of records then those statements don't really apply IMHO
Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] --------------------------------------------------------- Macromedia Associate Partner www.macromedia.com --------------------------------------------------------- Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com ----- Original Message ----- From: "Michael T. Tangorre" <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Tuesday, July 29, 2003 7:48 AM Subject: Keys and Data Types > 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=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Get the mailserver that powers this list at http://www.coolfusion.com
