Working with SQL server with isolation level "read committed snapshot", we routinely write data to the database and read it further on in the context of the same transaction. Usually when reading from the database we see our own uncommitted changes but only committed changes made by others. We assumed that this is the expected behavior .
We now found that in some relatively rare cases we don't see the values we've written - only previously committed values.
Any ideas what might be causing the inconsistency?