I talk about one scenario where the system table sys.sysprocesses almost led us down the wrong path.

After seeing this question pop up on forums multiple times, I wrote a quick tip about enforcing unique constraints where order doesn't matter.