Lynn Pettis (1/10/2014)
If you are routinely using cursors in your production code you are more than likely doing things wrong. Cursors should be avoided for most database activity. The only time I have used cursors has been for maintenance routines or one off processes, and even then I try to limit them as much as possible.
Well Lynn... One of the issues/problems I'm facing is a 3rd party software product that I will be ultimately supporting. What I've seen is the SQL code base is seriously out of date. The latest issue where I blew a cork over was a CURSOR in a TRIGGER.... :w00t::w00t::w00t::w00t:
I have suggested to my boss that the 3rd party software provider get themselves a GOOD SQL Server data modeler and to start cleaning up the legacy code.
It is like looking at code through a time warp. ANSI 89 code standards.
My battle rages on....
Kurt
Kurt W. Zimmerman
SR DBA
Lefrak Organization
New York, NY
http://www.linkedin.com/in/kurtwzimmerman