I was working with a customer today to diagnose a SQL performance issue. They had an interesting and very clever SQL query design practice I wanted to share.
Every query embedded in their in-house applications had a comment embedded in it that identified the library and function containing the query. When you ran diagnostics looking for blocking queries you could see this data and have a pointer back to the offender.
10/10 smart cookie thinking there.