SQL Server OPTIMIZE FOR UNKNOWN to disable parameter sniffing at query level

Hi Friends, Last week, I blogged about Trace Flag 4136: https://www.sqlservergeeks.com/sql-server-did-you-know-about-trace-flag-4136/ and bunch of other posts related to parameter sniffing: https://www.sqlservergeeks.com/sql-server-using-optimize-for-query-hint/ https://www.sqlservergeeks.com/blogs/AmitBansal/sql-server-bi/8/forceseek-hint-in-sql-server-2008-part-i https://www.sqlservergeeks.com/sql-server-forceseek-hint-in-sql-server-2008-part-ii-working-with-parameter-sniffing/ I got a question from reader asking me …

SQL Server OPTIMIZE FOR UNKNOWN to disable parameter sniffing at query level Read More