GUID vs Identity on a table performance My question is using a guid(data type unique identifier) versus using identity specification(data type int). Are there any articles where it talks about why you would use one versus another? I'm at a new company using guid and it seems alot slower but maybe its my imagination. Amazingly this is the first place I've seen it used for the uniqueness of a row. Any help or thoughts you have as to why use one versus the other?
There are certain situations where a GUID might be needed, but in general I'd advise against it.   The main reason is that GUIDs are, by their nature, random.  So using them as an identity column essentially means you're storing your rows randomly.  With a typical incremental primary key, the data is sequential.   Table scans are usually more efficient, etc.

In the end, there are tradeoffs with either situation.   Brent Ozar has an older article on the topic:  https://www.brentozar.com/archive/2014/08/generating-identities/