Top "Parameter-sniffing" questions

SP taking 15 minutes, but the same query when executed returns results in 1-2 minutes

So basically I have this relatively long stored procedure. The basic execution flow is that it SELECTS INTO some data …

sql sql-server stored-procedures sql-server-2005 parameter-sniffing
What are the main differences between OPTION(OPTIMIZE FOR UNKNOWN) and OPTION(RECOMPILE)?

I run into the classic Parameter Sniffing issues in SQL Server 2012. Based on some research I found multiple options around …

sql sql-server tsql sql-server-2012 parameter-sniffing
SQL poor stored procedure execution plan performance - parameter sniffing

I have a stored procedure that accepts a date input that is later set to the current date if no …

sql sql-server tsql sql-execution-plan parameter-sniffing
Multi-tenant SQL Server databases and parameter sniffing

I have a multi-tenant database in SQL Server 2012 where each tenant's rows are identified by a tenant_id column (aka …

sql-server performance entity-framework multi-tenant parameter-sniffing