This could be an exception, but as a general rule, disk replication does not allow for data integrity for database without gaps in data integrity protection.  The first is that...

No problem - I just took some exception to some of the language, based, I am sure, on decades of trying to get people to understand this.  Showing a NULL...

Nick, I think that technically, NULL does in fact mean unknown.  Both TRUE = NULL and FALSE = NULL are evaluated as false.

Sorry, but you said it again.  You imply that NULL is not meaningful.  It is, and it has a very specific meaning in three state logic.  If you use three...

• This reply was modified 3 years, 10 months ago by  rick-1071254.

I agree with Nick, but let's go even father.  NULL is not a meaningless value.  NULL indicates a valid state in three state logic.  To simply replace it with some...

The truly sad part about this discussion is the lack of understanding of data integrity and consistency.  Sigh.

This is getting tiring.

Except snapshot isolation does not automatically do what you say as it operates on an individual statement level.  So each subsequent query might still use different data.

Yes,...

Snapshot Isolation doesn't let you for example just write a query where you can say show me the query based on the data from 10 minutes ago.

I don't know snapshot...

Do you expect your bank account to be locked while you page through your transaction history?

Not if I am the only one accessing it, which is exactly what multi-version consistency...

Snapshot isolation?

Bingo.  And there are other solutions with other databases.

And, no, you are incorrect about the problem, which is stated quite clearly in the first sentence of the section labeled,...

ZZartin -

Getting a second page of data is not rerunning a query.  It's getting more data from a single query.  That is what is under discussion in this article and...

Nope, just wrong.  Multi-version read consistency does not introduce phantom rows - it gives a consistent view of data at a single point in time.  Databases are state machines -...

• This reply was modified 5 years ago by  rick-1071254.
• This reply was modified 5 years ago by  rick-1071254.

ZZartin -

I think this is another example of a basic misunderstanding.  If the result set used to build the pages is different from one set to another, it most definitely...

"Design your system for it"

Whoa, slow down, let's not get all crazy here.  <g>  Violent agreement.

Jeff -

There are other options out there.  Databases that use multi-version read consistency do exactly what you are asking - present an accurate picture of the state of data at...