possibly another process grabbing the admin session before you can do it.

I would try and use the -m startup option with a program name associated. e.g. -mSQLCMD and then connect...

please please do NOT use cursors for this

standard construct for a batch update where you have a KEY (or set of columns) that you can use to filter what has...

Sam - did you read my comments?

Adding those indexes are not necessarily what needs to be done (as recommendations from the engine are just that)

and is the field I mentioned...

I'm curious - do you have 2 processors with 5 cores each with HT active? or 2 * 10 cores = 20 HT?

Regardless of it I would probably change that...

your "requirements" do not match what you trying to do on the sql so please do clarify it exactly.

To get the records added today - which is what your subquery...

you need to learn to explain your requirements better - just stating that for a small sample of data you need this output is not enough.

Even with the latest output...

Apologies I should have remove the t1. from the order by when I added the outer select to filter on balance.

Now you have added a further block inside the query....

select *
from (
    select t1.Account
         , isnull(
         ...

without having sample data its hard to tell.

but try

$Failed  = $csv | Where-Object {$csv.Result -eq 'Failed'}|select -property Batfile

what was the exact create index statement?

and if this was on the same machine that you have with a maxdop of 1 that is likely normal and in this case...

Always makes wonder when I see a machine with 12 cores and maxdop = 1.

Has it been proven that for this machine this is the correct setting or was this...

duplicate entry. Please post any reply on https://www.sqlservercentral.com/forums/topic/developing-ssis-packages-in-vs-2019-and-running-them-on-sql-server-2014-and-2016-2#post-3705508

When you create the project on SSDT (VS) you need to select the target SQL Server version - once you select 2014 you can use them on that SQL Version

Think that error is on your pc - not the server.

your pc may be struggling or your version of SSMS has issues - better to install the latest one and...

if that regulated then installing Visual Studio on the server is also not allowed - again licensing issues.

using OpenXML (2.9 better than 2.5 but harder to install) is one way.