Finding bad code in stored procedures
Sometimes we inherit some badly designed database and we need to pinpoint the stuff we need to fix first, which is the longest running queries and the queries that use transactions ( transactions aren’t bad, but without proper usage they’re dangerous), so i have this small query that gives us all the stored procedures that [...]
Continue Reading →