I use DelimitedSplit8K across multiple functions & sometimes it is used several times in the same function.
However, I am noticing a significant decrease in performance & so I want to double-check. I'd like to start using DelimitedSplit8K WITH (NOLOCK). Is there any possibility that two different queries can collide/overlap in data if I do that? Also, would I see a performance increase?
Lastly, I learned from another post that I should be using cross apply rather than inner join when I use DelimitedSplit8K. Are there other things to keep in mind?