That's true for snapshot isolation mode. However,the chart shows that Read Committed Snapshot also ensures Repeatable Read, no phantom reads, and no missing/double reads. Since for Read Committed Snapshot, consistency is guaranteed only for the Statement, I believe you can still have repeatable read (and the other) problems. When the same statement is run a second time, it will get a (possibly different) consistent set of rows as they existed when the second statement started.