Long time ago we ran several large insurance websites, fairly standard SQL Server backend.

Once day I got into work and a slightly panicky dev said "We need to change the primary key on all the tables"

It was using an int and at the current rate of data entry, was going to blow the maximum record number in a couple of days.