>>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.