Blog

(Articles with tag:MS SQL Stored Proceudre) - Remove Filter

Do You Use Stored Procedures In MySQL or MS SQL or Any Other Database?

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.

How to stop CPU Spikes as a result of parameter sniffing while the MS SQL stored procedure is executed?

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.