I use guid's
On Feb 2, 2012 6:51 AM, Kirsten Greed kirst...@jobtalk.com.au wrote:
Hi All
I am interested in making my application occasionally connected.
My app uses SQL Server and the tables have identity keys (auto
incrementing numbers)
I can see this will be a problem if
If your only talking a small number of clients you can play with seed/increment
values.
Eg:
Node 1: Seed = 1, Increment = +2
Node 2: Seed = 2, Increment = +2
Node 3: Seed = -1, Increment = -2
Node 4: Seed = -2, Increment = -2
You can also assign ranges (and run the risk of running out of
+1 for guids. I use them as PK in a sync framework app.
On Thu, Feb 2, 2012 at 6:59 AM, David Ames david.a...@nga.net wrote:
** **
If your only talking a small number of clients you can play with
seed/increment values.
** **
Eg:
Node 1: Seed = 1, Increment = +2
Node 2:
Depending on your use cases and scale requirements, GUIDs a good choice.
An engineer at one of the companies I work with did a good chunk of
research and we resolved to use integers for our use cases:
http://www.google.com.au/webhp?ion=1#sclient=psy-abq=guids%20index%20fragmentation
My $0.02 is
Kirsten has lots of tables already created with traditional PK IDENTITY
columns, so I'm guessing that converting the PKs would be a nightmare.
Perhaps a compromise is the answer: add an indexed Guid column to those
tables that might find it useful in sync processing. That Guid is
effectively
I did find a mention on stack overflow that suggests using a separate sync
key. It doesn't mention GUIDS
http://stackoverflow.com/questions/7184372/how-do-you-sync-databases-using-m
s-sync-framework-when-tables-are-using-identity
What data type would you use to store guids in the database?
The data type is called uniqueidentifier
Greg
On Thu, Feb 2, 2012 at 11:01 AM, Kirsten Greed kirst...@jobtalk.com.auwrote:
** **
I did find a mention on stack overflow that suggests using a separate sync
key. It doesn’t mention GUIDS
Anyone recommend a good place to get some C# training?
We are a Delphi house that's moving to C# so don't need a how to program
type course, more an intermediate level course that's more showing the
.NET framework's wares and how it's done in C#
Thanks in advance.
Richard Moore
Analyst
I cannot recomend any training houses as I'm in NZ, but I can recommend the
paid for Pluralsight Training. As experienced as I am, I still get lots of
value from their courses.
http://www.pluralsight-training.net/microsoft/
On 2 February 2012 14:35, Richard Moore