September 2010
Intermediate to advanced
1704 pages
111h 8m
English
SQL Server 2008 introduces a few new features and capabilities related to query optimization and query performance in an attempt to deliver on the theme of “predictable performance.” The primary new features and enhancements are as follows:
• An enhancement has been added to the OPTIMIZE FOR query hint option to include a new UNKNOWN option, which specifies that the Database Engine use statistical data to determine the values for one or more local variables during query optimization, instead of the initial values.
• Table hints can now be specified as query hints in the context of plan guides to provide advanced query performance tuning options
• A new FORCESEEK table hint has been added. This hint specifies ...