:[EMAIL PROTECTED]]On Behalf Of Daniel Aioanei
Sent: Wednesday, 10 July 2002 9:00 PM
To: [EMAIL PROTECTED]
Subject: Re: [ADVANCED-DOTNET] Auto-increment replacement
Hi,
GUIDs are also very usefull in asynchronous processing inside a
client-server environment. The client can generate the GUID
Hi,
GUIDs are also very usefull in asynchronous processing inside a
client-server environment. The client can generate the GUID and send a
message to a MSMQ queue (maybe using Queued Components), and the server can
later insert it in the database. This way the client knows ahead of time the
k
what cost?
Bill
-Original Message-
From: Moderated discussion of advanced .NET topics.
[mailto:[EMAIL PROTECTED]]On Behalf Of Beauchemin, Bob
Sent: Monday, July 08, 2002 7:28 PM
To: [EMAIL PROTECTED]
Subject: Re: [ADVANCED-DOTNET] Auto-increment replacement
Only one other drawback,
.
[mailto:[EMAIL PROTECTED]]On Behalf Of Avi Nahir
Sent: Tuesday, 9 July 2002 4:02 PM
To: [EMAIL PROTECTED]
Subject: Re: [ADVANCED-DOTNET] Auto-increment replacement
http://sqlwire.com/brief.asp?1985
The Cost of GUIDs as Primary Keys
Article: Posted 3/19/2002
Source: JNSK
In this article, Jimmy
[EMAIL PROTECTED]
Sent by: "Moderatedcc:
discussion of advanced .NET Subject: Re:
[ADVANCED-DOTNET] Auto-increment replacement
topics."
<[EMAIL PROTECTED]
VELOP.
http://sqlwire.com/brief.asp?1985
The Cost of GUIDs as Primary Keys
Article: Posted 3/19/2002
Source: JNSK
In this article, Jimmy Nilsson presents the pros and cons of using GUIDs as
the datatype for primary keys in SQL Server 2000. In doing so, he shows you
test results that hint of performance
Behalf Of Michael Potter
Sent: Tuesday, 9 July 2002 1:56 AM
To: [EMAIL PROTECTED]
Subject: [ADVANCED-DOTNET] Auto-increment replacement
Since using identity primary keys (or auto-increment)
are problematic during appends, I was considering an
alternative pattern for future development.
In the
PROTECTED]]
Sent: Monday, July 08, 2002 10:56 AM
To: [EMAIL PROTECTED]
Subject: [ADVANCED-DOTNET] Auto-increment replacement
Since using identity primary keys (or auto-increment)
are problematic during appends, I was considering an
alternative pattern for future development.
In the past I have used GUIDs
Since using identity primary keys (or auto-increment)
are problematic during appends, I was considering an
alternative pattern for future development.
In the past I have used GUIDs as the primary key out
of necessity. The GUID primary keys are generated
locally and are pretty much guaranteed to b
