References https://hackernoon.com/why-parameter-sniffing-hurts-your-sql-query-performance-d73c0da71fbc https://blogs.technet.microsoft.com/mdegre/2011/11/06/what-is-parameter-sniffing/ https://www.mssqltips.com/sqlservertip/3257/different-approaches-to-correct-sql-server-parameter-sniffing/