That's correct, @grahamwade-69740. As per my understanding, I think the NOLOCK hint is applied to a table executing the query, whereas the READ UNCOMMITTED is at a session-level....

Thanks, @ReportThrall.  It is in my to-do list to compare the performance between different transaction isolations and publish it. I will keep you posted.

Totally agree with you @bryant-mcclellan

Thank you for your comments, @mvdba.

Completely agree with your view @jyoung. The only difference is I don't have a separate environment for posting within my infrastructure. So, after the ETL cleansing in stage,...

Thanks. Yeah, I agree on your point as well. But I personally feel that its easier to manage multiple packages in the master packages instead of creating SQL Agent jobs...

Yes, I agree with that.

For obvious reasons, I won't be able to share the data here, but it is a report, which fetches all the tickets that had been sold...

Yes, you're correct. In fact, as a developer, I always aim to write code without using any UDFs in the statements. However, in my scenario, we had a lot of...

Thanks a lot for providing your suggestions.

Thank you for your comment.

Well, I think the example that you have given is valid and holds good for this scenario, however, my business case was a totally different one,...