Question : Can having both the SET TRANSACTION ISOLATION LEVEL READ COMMITTED and WITH (NOLOCK) on all tables in SP […]
Tag: hints
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 […]
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 : […]
What cases benefit from the Reduce, Replicate, and Redistribute join hints?
Question : The From Clause Documentation starting with SQL Server 2008 briefly mention 3 join hints and their basic mechanisms: […]
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 : […]
Add query hints to a CROSS APPLY [duplicate]
Question : This question already has an answer here: Use NOLOCK hint when calling table valued function (1 answer) Closed […]
Using a filtered index when setting a variable
Question : I know from other questions and posts that when SQL compiles a query plan it can only use […]