| Arnie Rowland 2006-11-30, 5:17 am |
| I believe that the person that arms themselves with the best information,
makes the best decisions.
So, with that in mind...
GUID -Identity and Primary Keys
http://sqlteam.com/item.asp?ItemID=2599
GUID -Is not Always GOOD
http://bloggingabout.net/blogs/well.../03/15/598.aspx
GUID -The Cost of GUIDs as Primary Keys
http://www.informit.com/articles/ar...sp?p=25862&rl=1
GUID -Uniqueidentifier vs. IDENTITY
http://sqlteam.com/item.asp?ItemID=283
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Nadia Amir" <nadia.amir@aku.edu> wrote in message
news:O97T0eEFHHA.1020@TK2MSFTNGP05.phx.gbl...
> Hello All
>
> Right now we are in process of redesigning our database and we would
> completely redesign our schema . The debate is going on in our group that
> which one to use GUID or Identity column in our tables.
>
> I am not in a personal favors of any one of it. Traditionally I have
> always used identity columns in SQL and this is a very new idea for me and
> I would to try it as well like every lazy programmer ;) . I would like to
> request the groups preferences of using GUID or identity column which
> would help me to decide . Also if any body has used GUID and encounter any
> problems or easiness then do let me know
>
> Any help/comments in this regard would be appreciated.
>
> Thanks
>
> Nadia
>
>
|