RowGuid or Identity

• rschiefe

  SSC Veteran

  Points: 284

  More actions

  January 21, 2004 at 4:00 pm

  #82140

  Any suggestions or pros/cons in relation to using RowGuid(is RowGuid) vs. Identity(seeded) as the unique idenitifier?

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  January 22, 2004 at 12:57 am

  #491067

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=65&messageid=12455

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=17329

  Hope these links are of any value for you

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

• tymberwyld

  SSCertifiable

  Points: 7810

  More actions

  January 26, 2004 at 6:53 am

  #491591

  In my opinion, I would never in my life use an Identity field.  But that's because I've created my own Synchronization program rather than using Replication.  Identity Fields are very evil, especially for a programmer who has to deal with your database (and you'll find that you need numerous "hacks" as programmers move into .NET).  All that unneccessary programming can be spent elsewhere if you stick with ROWGUIDs which are very .NET friendly.