3

Let's say I have enabled change tracking on 200 tables in a database. Since the change tracking value change in the scope of database. What if I reach the max value of BIGINT?

user3057235
  • 51
  • 3

1 Answers1

8

In order to reach bigint limit, you have to change 1 million rows in your database every second during the next 292471 years. Good luck reaching it.

Roger Wolf
  • 7,307
  • 2
  • 24
  • 33
  • I was just working out a similar "think about the numbers" value - you can make ~730 million changes per second if you "only" need the system to work for 400 years. – Damien_The_Unbeliever Oct 20 '14 at 07:28