DelimitedSplit8K WITH NOLOCK?

I think it would be best to fully understand the oft-misunderstood (including myself) WITH NOLOCK

do some reading on it so that you personally fully understand what it does

https://www.sqlshack.com/understanding-the-impact-of-nolock-and-with-nolock-table-hints-in-sql-server/

2 Likes