Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aravindt77
Posting Yak Master
120 Posts |
 Posted - 2007-06-12 : 00:36:28
|
| Hi,Warm Wishes to All !I would like to know , is that any advantage in usingUniqueIdentifier Column as a Primary Key colum in atable....Its merits and demerits in using these data type columnsin a table as Primary KeyThanks Aravind |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-06-12 : 00:48:58
|
| see this article: [url]http://databases.aspfaq.com/database/what-should-i-choose-for-my-primary-key.html[/url]Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-06-12 : 00:49:13
|
note that if you do use it, you can use NEWSEQUENTIALID() as the default to prevent fragmentation.guids are useful if you need an id that must be GLOBALLY unique, across all your servers, subsidiaries, planets, etc.
elsasoft.org |
|
|
|
|
|
|
UniqueIdentifier as Primary Key in Table