Glad it is resolved, thanks for the solution

Can't see the latest screenshots.

With the validation error 'MSSQLSELSERVER' exists you could try a repair install

Or try to install a named instance instead of the default instance (which gets the...

Likely there is some WMI corruption on your system that must be fixed first. ( error mentions wmi server, and the first error was regarding countername)

From what I can find on the internet they fixed lodctr /r in system32 by running it in syswow64 and then back in system32

https://answers.microsoft.com/en-us/insider/forum/all/possible-performance-counter-problem-on-win10/3a5c22cb-1425-4d26-99e7-4ec46940b9a1

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