Added the NOLOCK hint. \#2 issue is resolved now