O'Reilly logo

Microsoft SQL Server 2008 R2 Administration Cookbook by Satya Shyam K Jayanty

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Implementing table hints for advanced query tuning performance

The table hints are similar to query hints that have been part of SQL Server since SQL Server 2000. The hints are useful to override query optimizer behavior during SELECT, INSERT, UPDATE, and DELETE execution tasks. Similarly, using the index hints in a TSQL query can reduce the query optimizer from choosing a specified execute plan. There are certain restrictions on using hints, such as both NOLOCK and HOLDLOCK cannot be used together.

SQL Server 2008 introduced a new feature called FORCESEEK table hint that will force seek over a scan during the query execution. Not all the time, query optimizer may choose an effective plan. Also, if the data platform is highly volatile, it requires ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required