Do you have a question? It reads like a statement

That's an unusual error. I believe your windows wmi performance counters are corrupt

Cannot load Counter Name data because an invalid index https://success.trendmicro.com/solution/000152298

Recommendation: uninstall sql 2019

Fix Wmi performance counters https://docs.microsoft.com/en-us/troubleshoot/windows-server/performance/rebuild-performance-counter-library-values

Reboot...

Still finding ntext datatypes in sql server reporting services 2019 🙁

It would be easier if you posted the T-SQL table definition and some sample data instead of having it to type over from a screenshot.

My guess:

select case, flow, note

from case...

Write a batch that periodically checks new items based on a timestamp? Do the records have a modified timestamp? (better to check on one column)

Thanks for the keyword "parallelism deadlock" Grant. Lead to intra-query parallelism with more information on the internet.

As by your recommendation solved with a query hint.

We use SSIS but it is picky on metadata (so not really suited for excel files) and I found the error handling uneasy.

No user friendly error messages ( metavalidation failed...

Still wondering why something likely as importing a csv is still so hard using the sql server tools

Not sure what the question is.

Is it about a checklist what to do if there is an outage? Work it out with the team / management / stakeholders.

Is it about...

Not relevant, but why are you still developing for SQL Server 2008 RTM 11 years later ( RTM released in 2010 )?

Thanks Jeff. Now investigating sql plan guides for additional nudges.

Summer has arrived + 25 degrees Celsius

@TestContributions MONEY=NULL OUTPUT

you can find the value afterwards in @TestContributions

if you don't specify @TestContributions it will assume the default value NULL

Can you post the DDL of the tables so it...

No idea, have you tried auto adjust buffer size ? https://www.mssqltips.com/sqlservertip/4221/improving-data-flow-performance-with-ssis-autoadjustbuffersize-property/

I don't know of any official recommendation.

A practical reason could be that it is faster to relocate a 64 GB file than a 2TB one

There is an recommendation to have...

Apparently you are on service pack 2 https://sqlserverbuilds.blogspot.com/