If your session isolation level is 0, and you need to read only committed changes to the database, you can use the at isolation level read committed clause.