SQL Server 2017 - Parameter Sniffing We are moving from SQL Server 2014 to 2017, I see in the options that we have Parameter Sniffing, I believe we should we keep it OFF, but what about the options that we used in 2014 to avoid that? can be affected in 2017, like creating local variables of the parameters and put option(recompile) to the queries.
All the ways of influencing parameter sniffing before SQL 2017 remain.  There's just a new database scoped configuration option to turn off parameter sniffing entirely.