Tag : nolock - SentryOne Team Blog

Tag: nolock

Should I use NOLOCK against #temp tables?

Aaron Bertrand (@AaronBertrand) addresses a popular theory that NOLOCK can substantially reduce locking overhead against #temp tables.

Bad habits : Putting NOLOCK everywhere

Aaron Bertrand (@AaronBertrand) discusses the NOLOCK hint in SQL Server, and why you want to avoid slapping it onto every table mentioned in every query.