I need to apply a query hint (like
NOWAIT
or NOLOCK
) to the CROSS APPLY
in this query. How do I do it:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SELECT *
FROM sys.objects obj WITH (NOLOCK)
INNER JOIN sys.stats stat WITH (NOLOCK) ON stat.object_id = obj.object_id
CROSS APPLY sys.dm_db_stats_properties(stat.object_id, stat.stats_id) sp
I don't have access to the function contents (for obvious reasons.)
I went ahead and removed the repro from the question to make it more clear. I'm less concerned about the ability to reproduce the blocking. (It's also happening at customer environments, and in the First Responder Kit in issue # 2548.)
Asked by Brent Ozar
(43335 rep)
Aug 27, 2020, 02:09 PM
Last activity: Aug 27, 2020, 02:44 PM
Last activity: Aug 27, 2020, 02:44 PM