• Iam working on 8 terabytes of data, where i found the vital role of NOLOCK.Definetly it improves the performance