Tuesday, September 24, 2019

Clever SQL query development practice

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.