>>>>I am looking more and more at ROWGUIDs for my surrogate PKs, but I am not sure about the performance implications, compared to integer PKs.
>>>
>>>That's a good alternative, Chris. I'm using indentity columns because SQL Server (at least 7.0) does the work of creating the surrogate key for me. Then again, I'm lazy.< bg >
>>
>>You can set the default of a uniqueidentifier (i.e. GUID) column to NewID(), which generates the GUID for you.
>
>Thanks for the heads up, Trey. I'm pretty much a newbie with SQL Server so I haven't learned all the ins and outs.< Heads off to Whil's site to order Gary DeWitt and Chaim's book the the subject >
You will find that the book is much too rudimentary to have any real value. You'd be better off going with something a little more industrial strength.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only