• Hi,

    Probably best off looking up Query Hints in BOL:

    http://msdn.microsoft.com/en-us/library/ms181714.aspx

    It's pretty straight forward