the universal cursor, uncommitted marathon, string concatenation in dynamic SQL, unbounded scrollable cursors, thread hogs, and fatal-error-on-deadlock — are the patterns that work in development and fail in production. Recognize them in legacy code and eliminate them.