GilaMonster (1/10/2014)
No, it's an unnecessary use. If the data is static during the day then there aren't going to be any X locks around to block the reports and so adding nolock is a waste of typing
So am I mis-remembering situations in which long running read-only queries have caused blocking of other read-only queries ?