FORCESEEK Table Hint in SQL Server 2008

In prior versions of SQL Server, there was a way to force the optimizer to consider an index in the execution plan – however, there was no way to always force it to do a seek operation. That has now been added in the next release (tested against CTP5). A point of caution here – don’t be trigger happ

Read More - Register for Free Membership