09. What Parameter Sniffing ISN’T

Some things get mistaken for parameter sniffing issues when they’re unrelated. For example, when you run the same query in two different environments and get two different plans, it might not have anything to do with the parameters at all: the data distribution might be different in the two environments, or they might have different…

Some things get mistaken for parameter sniffing issues when they’re unrelated. For example, when you run the same query in two different environments and get two different plans, it might not have anything to do with the parameters at all: the data distribution might be different in the two environments, or they might have different...
Menu