Tips for using SQL Server 2012 Table Hints One of the ways to increase the queries performance is using the SQL Server 2012 table hints. The table hints specify a locking method to be used by the query optimizer with this table, specify the locking granularity for a table, or one or more indexes to be used by the query...