Re: Making an application that uses identity keys occassionallyconnected

2012-02-04 Thread noonie
l Chesnut > *Sent:* Saturday, 4 February 2012 3:20 PM > *To:* **ozDotNet > ** > *Subject:* RE: Making an application that uses identity keys > occassionallyconnected > > > ** ** > > Kirsten, > > > > One issue with GUID keys is that they are n

RE: Making an application that uses identity keys occassionallyconnected

2012-02-03 Thread Tony Wright
egLow.com) Sent: Saturday, 4 February 2012 4:43 PM To: 'ozDotNet' Subject: RE: Making an application that uses identity keys occassionallyconnected The problem with NEWSEQUENTIALID is that it fixes the wrong problem. One of the main reasons for using GUIDs in the first place is so

RE: Making an application that uses identity keys occassionallyconnected

2012-02-03 Thread Greg Low (GregLow.com)
dotnet-boun...@ozdotnet.com] On Behalf Of Kirsten Greed Sent: Saturday, 4 February 2012 3:39 PM To: 'ozDotNet' Subject: RE: Making an application that uses identity keys occassionallyconnected Noonie Were you using NEWSEQUENTIALID() in the app that had problems in production?

RE: Making an application that uses identity keys occassionallyconnected

2012-02-03 Thread Kirsten Greed
On Behalf Of noonie Sent: Saturday, 4 February 2012 12:05 PM To: ozDotNet Subject: Re: Making an application that uses identity keys occassionallyconnected Hi Kirsten, >From my experience, using GUIDs as surrogate primary keys works fine in development where sample data is only thou

RE: Making an application that uses identity keys occassionallyconnected

2012-02-03 Thread Bill Chesnut
MVP Melbourne, Australia _ From: Kirsten Greed [mailto:kirst...@jobtalk.com.au] To: 'ozDotNet' [mailto:ozdotnet@ozdotnet.com] Sent: Sat, 04 Feb 2012 12:40:51 +1100 Subject: RE: Making an application that uses identity keys occassionallyconnected Hi Noonie Thank

RE: Making an application that uses identity keys occassionallyconnected

2012-02-03 Thread Kirsten Greed
: Saturday, 4 February 2012 12:05 PM To: ozDotNet Subject: Re: Making an application that uses identity keys occassionallyconnected Hi Kirsten, >From my experience, using GUIDs as surrogate primary keys works fine in development where sample data is only thousands of rows. It bites viciously

Re: Making an application that uses identity keys occassionallyconnected

2012-02-02 Thread Greg Shaw
you use to store guids in the database? > > > > > > > > __ > From:ozdotnet-boun...@ozdotnet.com > [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Greg > Kennedy > Sent: Thursday, 2 February 2012 11:08 AM > To:

Re: Making an application that uses identity keys occassionallyconnected

2012-02-01 Thread Greg Kennedy
zdotnet.com] *On Behalf Of *Greg Kennedy > *Sent:* Thursday, 2 February 2012 11:08 AM > *To:* ozDotNet > *Subject:* Re: Making an application that uses identity keys > occassionallyconnected > > ** ** > > I think the sync framework will crack a fruity if the Guid is

RE: Making an application that uses identity keys occassionallyconnected

2012-02-01 Thread Kirsten Greed
abase? _ From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Greg Kennedy Sent: Thursday, 2 February 2012 11:08 AM To: ozDotNet Subject: Re: Making an application that uses identity keys occassionallyconnected I think the sync framework will crack a f