• :rolleyes:

    One of the issue I come across is that some developers believe that writing a stored procedure or even a set based query will slow them down from cutting code and prevent them from bug fixing.

    They dont always want to see that requirements of the project include:getting the project completed, having maintainable code, and performance has to be at least acceptable.

    But the main difference is the mindset: trigger-happy vs belt and braces (plus some scaffold...). The right answer is, of course, it depends.

    Even some dbas have this trigger happy mindset which to my experience has caused all sorts of issues. And some developers have even more of a stick-in-the-mud mentality and wont consider that there are other ways of working (bit like some of the dba I have known).