Looking at this post:
[What are the best practices for using a GUID as a primary key, specifically regarding performance?
I understand that if I want to use a GUID as the primary key then this should be non-clustered pk and then also create a clustered int unique index (autoinc).
I just want to confirm that with the setup above all joins would still work as usual ie. tables relate on the GUID primary key field? Also, it would appear that the int unique index field would have no relevance in my application and I would just ignore this completely in any queries/inserts/updates?