a4apple (5/2/2014)
Jack Corbett (5/2/2014)
Parameter sniffing won't cause the results returned to be incorrect it can cause a sub-optimal plan to be used skewing performance. If parameter sniffing causes incorrect results that's a bug and a very big one that I think would have been caught and fixed a long time ago.Jack, I only said since the data is not retrieved correctly may be check that aspect too.. I didn't mean that's the only root cause.
But parameter sniffing won't cause data to be retrieved incorrectly, just possibly not as quickly. There is no reason to consider parameter sniffing for incorrect results. For inconsistent performance yes, but not incorrect results.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question