How to proactively avoid parameter sniffing step-by-step
In the following blog post the so called „parameter sniffing“ is explained: http://blogs.msdn.com/b/axinthefield/archive/2014/01/09/sql-server-parameter-sniffing-with-dynamics-ax-just-plain-evil.aspx The purpose of this blog post is to explain the fix implementation steps a little more in detail: Notes: The kernel only hotfixes mentioned for MS Dynamics AX in the blog post above are minimum prerequisites. Because all kernels are cumulative I’d