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

[Stuart McLachlan]

Doh!   Didn't read it carefully enough.  I just saw Max() and PK and jumped in :(

-- 
Stuart

On 8 Aug 2015 at 15:34, John W. Colby wrote:

> 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
> >
> >
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
>