Now being exposed to the problem here are a few methods to address it: • Create SQL Server Stored Procedures using the WITH RECOMPILE Option

 • Use the SQL Server Hint OPTION (RECOMPILE)

 • Use the SQL Server Hint OPTION (OPTIMIZE FOR)

• Use Dummy Variables on SQL Server Stored Procedures

• Disable SQL Server Parameter Sniffing at the Instance Level

 • Disable Parameter Sniffing for a Specific SQL Server Query

https://www.mssqltips.com/sqlservertip/3257/different-approaches-to-correct-sql-server-parameter-sniffing/