Thanks Drew, Jeff for highlighting the alternative with DENSE_RANK. Interesting way to handle or exists

*edit *

• This reply was modified 2 years, 2 months ago by Jo Pattyn. Reason: Possbile wrong answer

Checkout https://www.sqlservercentral.com/blogs/how-to-get-live-execution-plan-using-extended-events

MS documentation on it https://learn.microsoft.com/en-us/sql/relational-databases/performance/query-profiling-infrastructure?view=sql-server-ver16

You can capture blocking with extended events on SQL 2019, but doesn't have alerting

Alerting can be done with xesmarttarget

https://spaghettidba.com/2022/02/28/recipe-5-killing-blocking-spids/

https://spaghettidba.com/2022/02/25/recipe-4-sending-alerts-via-email/

Is it possible to have an sql-script posted as code to reproduce your question so we don't have to open a possible dangerous excelfile

We update short support documentation when we are on supportduty. Usually by another person than who wrote the program

It's necessary to support the number of applications, can't know it all...

Page_latchup is mentioned in https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-os-wait-stats-transact-sql?view=sql-server-ver16

Can you post the matching DDL? Can you view the query plan?

Are there good indexes on c_b_party_comm

You can start by watching  https://www.brentozar.com/training/think-like-sql-server-engine/ series

At first it would overheat because the connection between the watercooler and its controller got loose. Long live the internet for instructions.

Also had some fun misreading the windows license a...

The joy of assembling a new pc and it boots

Good luck, thanks for posting the createMSDB

Pretty pre-pandemic in Belgium.  Work from home is more tolerated than pre-pandemic (up to 3 days in a week).

Lives returned to normal with only the healthsector wearing masks. The flu...

SELECT CompanyB.Value SourceValue, CompanyA.Value PartialMatch
FROM CompanyB
Left join CompanyA
on CompanyA.Value like '%'+CompanyB.Value+'%'

Deploy it at a test instance?

You can decompress a dacpac and view it's xml contents https://learn.microsoft.com/en-us/sql/relational-databases/data-tier-applications/unpack-a-dac-package?view=sql-server-ver16

I don't have experience with sql on linux

What have you tried?

Found an extensive troubleshooting list on stackoverflow https://stackoverflow.com/questions/64876580/sql-server-odbc-tcp-provider-error-code-0x274c

or https://stackoverflow.com/questions/57265913/error-tcp-provider-error-code-0x2746-during-the-sql-setup-in-linux-through-te