hints Archives - SQLServerGeeks

SQL Server: Plan Freezing & Plan Guides in SQL Server 2008 – Part II

June 14, 2011November 27, 2014 - by Amit Bansal - 2 Comments.

Hi All, In my last post, I talked about the basics of Plan Freezing. And i gave an example of a query that gets migrated from SQL 2005 environment to SQL …

SQL Server

FORCESEEK hint in SQL Server 2008 – Part II -working with Parameter Sniffing

May 17, 2011December 18, 2014 - by Amit Bansal - 4 Comments.

Hi Friends, In Part 1, I introduced the FORCESEEK hint in SQL server 2008 that can force the query optimizer to perform a seek instead of a scan on an index. …