coronaride (10/2/2012)
Not sure that I quite followed, but it sounded like you were setting READ UNCOMMITTED on the stored procedure that was doing the writing, not the reading. Is that correct?
The procedure does reading, in a form of a 3 joins + aggregation. Read uncommitted was set to prevent blocking when the reading occurs on high volume data.