OPTIMIZE FOR Archives - SQLServerGeeks

OPTIMIZE FOR query hint in SQL Server

November 20, 2014July 3, 2020 - by Kanchan Bhattacharyya - Leave a Comment

Hi Geeks, Many of us might have experienced that a query runs perfect for long time then suddenly it started performing very bad with no clues. After lot of investigation, we …

SQL Server TSQL – The TSQL Classes Stored Procedures: Parameter Sniffing Resolution

April 13, 2013December 23, 2019 - by SQL Geek - 2 Comments.

This blog is part of the series The TSQL Classes: Stored Procedure The link to previous post are given below. https://www.sqlservergeeks.com/sql-server-tsql-the-tsql-classes-stored-procedures-nested-proc-recursion-and-plan-caching/ https://www.sqlservergeeks.com/sql-server-stored-procedures-the-tsql-classes-stored-procedures-a-primer/ https://www.sqlservergeeks.com/sql-server-tsql-the-tsql-classes-stored-procedures-parameter-sniffing-resolution/g In last class, I talked about parameter sniffing; a …

SQL Server – using OPTIMIZE FOR query hint

February 27, 2012September 30, 2014 - by Amit Bansal - 5 Comments.

Hi Friends, I really do not know what motivates me or drives me to write this blog post at 12 midnight, just landed from Singapore and waiting for my BA flight …