tag:blogger.com,1999:blog-6806992453823338600.post5018564567691879675..comments2023-05-18T11:36:19.318-04:00Comments on SQL Server Newbie: RowGUIDJerry Hunghttp://www.blogger.com/profile/00173468802063778170noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-6806992453823338600.post-50078423457307009672011-11-03T05:20:11.332-04:002011-11-03T05:20:11.332-04:00It seems to me that Jerry Hung ment to say that, n...It seems to me that Jerry Hung ment to say that, newsequentialid() is better than newid() to have pk guid, which is correct since you avoid table splitting problem.Roberto Prevatohttps://www.blogger.com/profile/00847002118453678917noreply@blogger.comtag:blogger.com,1999:blog-6806992453823338600.post-37704186371538612432011-04-19T04:32:40.583-04:002011-04-19T04:32:40.583-04:00Also it is not 'better' to use newsequenti...Also it is not 'better' to use newsequentialid at all - you might as well just use an identity column.<br /><br />It says the same in the SQL Server documentation.Lord Zoltanhttps://www.blogger.com/profile/18416046190284445908noreply@blogger.comtag:blogger.com,1999:blog-6806992453823338600.post-3373917547894151362011-02-17T07:35:38.439-05:002011-02-17T07:35:38.439-05:00The RowGUID data type is uniqueidentifier with ...The RowGUID data type is uniqueidentifier with 'Is RowGuid' value = Yes and 'Default Value' = (newid())Anonymoushttps://www.blogger.com/profile/08276042543507378483noreply@blogger.comtag:blogger.com,1999:blog-6806992453823338600.post-71059169748155308272011-02-17T07:26:05.821-05:002011-02-17T07:26:05.821-05:00The setting of RowGuid=yes is correct for a GUID p...The setting of RowGuid=yes is correct for a GUID pk.Anonymoushttps://www.blogger.com/profile/08276042543507378483noreply@blogger.com