Question : I have a query that uses the FORCESEEK hint and runs fine on the server where the database […]
Tag: hints
Append hint with autotrace
Question : I’m doing a direct-path insert which executes successfully. When I try to autotrace the execution, I get the […]
SELECT lock only for inserts [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Why does the READPAST hint cause indexed views to be ignored?
Question : I am investigating using the READPAST hint to reduce resource locking in our application’s financial subsystem. It seemed […]
How to use merge hints to isolate complex queries in SQL Server
Question : I can understand that if I join individual queries that are “individually fast” the combination may become slow […]
Is there a behavior change between SQL Server 2000 and SQL Server 2008 R2 OPTION (FAST 1)?
Question : This is question 2 of 2 related to the FAST query hint. Background Information (as an aside, I’m […]
Does using a read committed isolation level and a NOLOCK query hint impact performance?
Question : Can having both the SET TRANSACTION ISOLATION LEVEL READ COMMITTED and WITH (NOLOCK) on all tables in SP […]
Grant users privilege to use QUERYTRACEON 9481
Question : Microsoft suggests using OPTION (QUERYTRACEON 9481) for queries that have “degraded” performance against SQL Server 2014 databases running […]
What is the difference between “OPTION (OPTIMIZE FOR UNKNOWN)” and “OPTION (USE HINT(‘DISABLE_PARAMETER_SNIFFING’))”
Question : Can you tell me what is difference between OPTION (USE HINT(‘DISABLE_PARAMETER_SNIFFING’)) and OPTION (OPTIMIZE FOR UNKNOWN)? Answer : […]
How to use merge hints to isolate complex queries in SQL Server
Question : I can understand that if I join individual queries that are “individually fast” the combination may become slow […]