Today is Friday and tomorrow is the weekend. I just thought let us explore something new but additionally give you all a quick puzzle to explore.
SQL Server Denali has new Query Hint – FORCESCAN. In earlier version of SQL Server we already have Query Hint FORCESEEK but now the counter part also exists. The quick understanding is there will be cases when FORCESEEK or FORCESCAN will be helpful and improve the performance for the query.
Now here is the quick contest -
1) Write a Query where using FORCESCAN hint which will improve the performance of the query.
2) Write a Query where using FORCESEEK hint which will improve the performance of the query.
Reference: Pinal Dave (http://blog.SQLAuthority.com)