When Stored Procedures Go Bad

added by DotNetKicks
11/4/2016 3:06:35 PM

8 Kicks, 456 Views

It is far easier to work out what is wrong with a slow-running SQL query than one that shows erratic performance. DBAs will groan when a process occasionally performs terribly without apparent reason. There is always a good chance that this is a symptom of the painful problem of parameter sniffing.