sachin6139 (6/4/2013)
I have 2 select statements. One with NOLOCK hint and other without NOLOCK hint. I am getting different result sets. Rows are same but there order is different. Why?
The order changes due to the way SQL Server reads pages with and without NOLOCK. This article will explain why:
http://thesqlguy.blogspot.com/2013/02/nolock.html
The article also explains why you shouldn't use NOLOCK, but that has already been covered above.
