Removed the with nolock option for all queries.