I have a few thoughts on this.

First - is this consistently returning the same number of rows?  Like if you run the query 10 times do you always get 1035...

I agree with Fredrico_Fonseca on the performance question - it depends on a LOT of factors and the EASIEST way to know if it helps or not is to test...

As a thought - is it a native backup or a 3rd party tool (like redgate) backup?  Is the backup encrypted? Can you restore the backup to another 2012 STD...

One option you could do (probably not ideal, but a possibility) would be to use something like the scripting agent in SSIS to open the file in excel (hidden window)...

That I am not 100% certain on, but in my opinion - I would buy some sort of SQL monitoring tool.  It will let you know when a deadlock occurs...

My opinion - this is likely not a database issue, but possible a configuration issue.

BUT to rule out database, I would do a dbcc checkdb to make sure nothing is...

The other bit of "fun" with that, on top of what ZZartin siad, is that the TLOG may be in use by other queries that could be inserting, updating, or...

Yep - you see that greyed out "script" button?  Click on a checkbox then click on the script button then cancel out of that window.

That script button will tell you...

I am not certain what you mean by "access the checkbox" in TSQL code, but I am 99% sure that all configuration options within SQL Server for all available features...

Personally - I would not do this on the SQL side.  The ONLY way I can think of to do this would be with dynamic SQL and to me that...

My opinion - every time I've seen an "unable to delete" error, or unable to copy, move, archive, etc, it has been due to disk failure.  I would run a...

• This reply was modified 3 years, 9 months ago by Mr. Brian Gale.

I wish my disk latency was down as low as 8ms... my lowest read stall is 11ms and the highest is 265869 ms; mind you that DMV is showing you...

I think it depends on your source.  I am assuming this is still the TAR source, in which case you would just need to treat it like a bunch of...

• This reply was modified 3 years, 9 months ago by Mr. Brian Gale.

What command are you using for tar?  If you are using the native tar built into windows 10, then you would run:

tar -tf <archive name>

which will give you the contents...

Have you tried unpausing it?

Personally, I am not a big fan of activity monitor.  It shows information in one nice dashboard, but even some Microsoft employees recommends against - https://redmondmag.com/articles/2021/08/25/activity-monitor-sql-server-performance.aspx.

I...