Maximizing Query Optimizer with Query and Table Hints - SQL Server 2005 & 2008
Hints are a powerful mechanism to force SQL Server to use alternate query plans. More often than not, the query optimizer does a fantastic job in creating the most optimized query plan for data access, but there may be numerous occasions when you would like to use alternate query plans to boost performance. Hints may adversely affect performance so should be used with care. In this breakout session, we first alert the DBAs on using Hints as they need to be sure that there is indeed a problem with the query plan.
Let us have a look at different types of Hints including Query & Table Hints with various concepts on SQL Server query processing architecture are also explained wherever relevant, to ensure that the audience gets the most out of the session.
Speaker focus
Knowledge is the power and you will gain by sharing it;
I'm an Independent Database expert, with over 16 years of experience in application designing, developing and managing database technologies using industry famous technologies & software. I have been working with SQL Server since version 4.2 (1996) and active member & moderator in Technet, MSDN, SQL-Server-Performance.com forums/websites and also writing for http://www.sql-server-performance.com website. I'm a regular speaker and volunteer (Ask The Experts) at SQL Server events such as SQLPASS, Tech-ed etc. and I was awarded as SQL Server MVP since the year 2006. I also update content & manage the website http://www.sqlserver-qa.net.
Other sessions from this conference