No, it's not a row total, as Steve noted.  It's the number of seek operations since the stats for that index were created.

One query that reads, say 5,000 rows, might...

Well, good luck.  Since your posts seem to disagree with themselves, I don't think I can be of any more assistance.

"we are getting emails of large queries taking longer than...

Hmm, do you have tables under different schema names?  Is it possible that dbo.same_table_name is empty, but some_other_schema.same_table_name has rows?

What is the "cost threshold for parallelism" setting?  If it's lower than, say, 50, you should seriously consider changing it.

Did you verify there are no physical issues -- controllers, NIC/communication...

Lordy... not another one... 🙁  Jumping straight to the final two questions in the "experienced" section...

Without loading it...

That's too much for a single q here.  You need to break this into separate qs, each with a single and specific q.

Your "first attempt" looks remarkably similar to the code I posted on an almost identical q of yours:

https://www.sqlservercentral.com/forums/topic/printing-the-highest-count#post-3889964

Nvm.

You can use a subquery, but you don't technically need it.  If branches tie and you want to list all tied branches, change to "TOP (1) WITH TIES".

            
May 30, 2021 at 5:50 am
            
#3889808

            
            
                                                
        

Then, as I stated before, you would need to put an UPDATE trigger on that table.

One trigger could handle all of the numeric, date, etc. columns in a table.

The triggers...

(1) Does the original table have an IDENTITY column?  Or a added_date column?

(2) Is the original table compressed (page or row compressed)?

(3) Have you checked to see if compression would...

Best guess, without any other details, is to cluster the dbo.BCPDailybalmasterydaily table on ( processdate, acctno ).  If those columns are not unique and there's an identity column on that...

This depends on your use of the sequence.  If you use the sequence often, you will want a larger cache.  If less often, a smaller cache makes more sense.

Also, be...

If, for example, you're trying to determine that, say, an int value is nearing 2,147,483,647, then you could use an UPDATE trigger for that.

If not along those lines, then, as...

It's likely safer to use sp_cycle_errorlog rather than running DBCC ERRORLOG directly.  The user must have sysadmin authority for using sp_cycle_errorlog.

IIRC, typically that error means that the file is locked,...