This is a fairly active database
If you can restore a static backup somewhere, and do analysis on that unchanging copy, I think you'll find that the weird behavior you're seeing goes away.
The default isolation level in SQL Server is READ COMMITTED. Under this isolation level, you read the data that is currently committed to the database. ...