All geek questions in one place

What happens when the timestamp overflows (rowversion)?

I am wondering if it is safe to compare timestamp values ​​in a table to get updated / inserted rows. (e.g. SQL Server RowVersion / Timestamp - Comparison ).

What happens if timestamp reaches its maximum binary value (8) in a very large / frequently updated database?

+6
source share
1 answer

It will not be.

If you do a million updates per second, every second, the timestamp will wrap around after about 585,000 years.

+12
source

Source: https://habr.com/ru/post/949067/

More articles:


All Articles