Generally, unless you have a specific need to use UUIDs/GUIDs, such as in replication scenarios, integers are the better choice. Kimberly Tripp has a great presentation on this subject if you ever get a chance to take one of her classes. She spends an hour detailing all the ways the use of GUIDs negatively impact database performance.
If using UUIDs, let SQL Server generate the values for you. SQL Server has a NEWSEQUENTIALID function that generates GUIDs in incrementing order, which can significantly reduce the fragmentation in the database. The use of this SQL Server 2005 feature can have a significant impact on the speed of large databases, although integers will always be faster. You could use both, having an integer as the main clustered PK, while maintaining a GUID as an alternate primary key, with a non-clustered index, in case you want to use that to look up a record. Kimberly Tripp is an authority on this subject and has lot of information on her Web site and in the PowerPoint slides from her classes. Her PowerPoint slides might not be on her public Web site. -Mike Chabot http://www.linkedin.com/in/chabot <http://www.linkedin.com/in/chabot> On Mon, Dec 20, 2010 at 12:34 PM, Brian Polackoff <[email protected]>wrote: > > So, anyone have any thoughts on which are better... Using CF8 Ent, SQL 2k5 > Ent and an enterprise application with millions of rows in the table? > > Thanks for all your feedback, > > Brian > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340178 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
