Showing related tags and posts accross the entire site.
Sorry, but there are no more tags available to filter with.
-
I read about GUIDs and is use as primary key to solve aoffline and replication problems. I need your advice if GUIDs will provide any benefit for the following design. I am currently working in an application where it has mulitple actors (users accounts) types.we used guids as primary keys for actors...
-
SQL2005NewSequentialID.zip Original Thread is loacted here http://community.codesmithtools.com/forums/t/2902.aspx I have run into the newsequentialid() as I to need to create a disconnected pc application. I have made changes to the latest SVN templates 677 I belive is what I start with. The changes...
-
My primary reason is that using the OUTPUT clause kills a whole bunch of birds with one stone. Getting the actual values back from the row solves a bunch of questions and issues i've seen around here related to default values. There doesn't seem to be any support for the OUTPUT clause at the...
-
I'd rather rely on sql server's newsequentialid and output clauses to solve this Is there any particular reason why? I can't see any benefit to doing so, and it has downsides, such as the fact that it requires a database round-trip before you get your Guid, and OUTPUT is slow : you have to...
-
This patch creates a new static class called Comb with one method NewGuid(). The GUIDs produced by this method are ordered, thus they will reduce index fragmentation in SQL Server. More details are in the file Comb.cs[t]. It is in respone to the end of this thread : http://community.codesmithtools.com...