There’s never been a SQL Server database where Kimberly didn’t see problems with stored procedure parameters. It’s so common that a name has been given specifically to the problem: parameter sniffing problems. But, what is parameter sniffing? Are there ways around it? What are the pros and cons? Can you detect that it’s happening?
Download this special training session as Kimberly discusses:
After you've registered and watched part 1, check out part 2 and see how SentryOne can help you solve these problems.