>>>>Hi all,
>>>>
>>>>I just attended a SQL Saturday in Dallas this past Saturday and I got the impression GUID's were not such a great idea for PK's. I would like to understand why that is, and what is the best choice for tables with lots of records.
>>>>Thanks
>>>>Tim
>>>
>>>Identity int (or bigint) fields are generally recommended. If you insist on using GUID, use NewSequentialID() function to generate them.
>>
>>Naomi,
>>
>>Can you give me some idea as to why Guid's are no longer the recommended way? There was a day, when GUID's was the recommended key since they were always unique accross all boundary's. An int may be smaller in the db but how on earth would I merge two tables together with an int for the key? I am not advocating either, just trying to get in the know.
>>
>>What does NewSequentialID() funchtion do that is different?
>>Thanks a bunch
>>Tim
>
>
>Another discussion on this topic which may be of help
http://forums.asp.net/t/1248405.aspxInteresting read, thanks. I didn't know about the fill factor.
Tim
Timothy Bryan