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

[John W. Colby]

Nope, never even heard of that one.  But isn't the PKID that I need but 
a matching value of PKSimmons stored in that max record.

John W. Colby

On 8/8/2015 3:28 PM, Stuart McLachlan wrote:
> 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.
>>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>