Do you use stored procedures?
Some developers said, we don’t use it. Too much of a hassle. We would rather use one development tool to encapsulate all in one set of code. I was interviewing a dot net developer for a web scarping project and I asked him, if he can show me what stored procedures he worked lately. I was amazed to realize that the developer has difficulties to identify different features in MS SQL and basically does not work with any SP. He said all is done within the entity framework and LinQ.
With one of our clients that we provide Remote DBA services, we recently encountered a situation where one of the frequently running stored procedures suddenly started consuming 100% of the CPU on the server.