How common an anti-pattern is representing GUID primary keys using character data?
I was pondering GUIDs as primary keys recently, and was reminded of the most egregious misuse of them I've ever encountered: This database contained a lot of Entity-Detail parent-child relationships, like Receipt, which had LineItems. Most of the Detail tables (LineItem in this case) used GUID primary keys. But instead of being stored u...