[dba-SQLServer] 2.45 billion rows and counting was PK Cast fails

[Stuart McLachlan]

Have you tried DBCC CHECKIDENT (myHumungousable, NORESEED)


On 8 Aug 2015 at 11:00, John W. Colby wrote:

> 
> While I can see the total storage (records) in the junction table,
> what I can't do is get a Max() of the Simmons PK in the junction table
> to see where I am in the process.  I was hoping that info would be in
> metadata somewhere but apparently not, it seems that it has to scan
> through the table looking for the max() value.  While I haven't let it
> run in a query window, trying to do that in a view timed out for
> obvious reasons.
>