>>>>>>>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.
>>
>>
>>I wouldn't say it has no real value, I learned a thing or two, but that's about it. I agree though, it's not the most thorough resource, and doesn't even really approach the concept of n-tier.
>>
>>George (and anyone else who is listening and is interested in development with SQL), watch the files section for a utility that I just uploaded that builds your SQL Server sprocs for you- if you are just getting started with SQL or even if you just do a heck of a lot of SQL development, it could really save you some time.
>
>What section is it in?
Client Server. Doesn't look like it's posted yet though...
Erik Moore
Clientelligence