Press "Enter" to skip to content

USE HINT In SQL Server 2016 SP1

Lori Brown documents the hints available with SQL Server 2016 SP1’s USE HINT syntax:

USE HINT ( hint_name ) Provides one or more additional hints to the query processor as specified by a hint name inside single quotation marks. Hint names are case-insensitive. USE HINT can be utilized without having to be a member of the sysadmin server role.

It’s an interesting list.