ashvindevil (9/23/2014)
I do not know why nolock hint has been used. Accurate result? What alternative do you propose?
Not using nolock? It's not a go-faster switch. It's a trade off of not being blocked for possible inaccurate results.
Can you think of anymore optimisation that can be done to this procedure?
Did you read the blog post I referenced?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability