In SQL Server 2008, which index hint will ensure that in index seek operation is used?......... http://blog.joggee.com/?p=116