My guideline for FK indexes is: put indexes in place that match the FK definition 100%, unless it is proven for that case it hurts regular operations.

And even then,...

And here's the bite in the back by cascading deletes !

The reason why we only use foreign keys "NO ACTION" is because we want to take full control over...

duplicate ip address?

My advise: read Brent's blog about SQL2022 to get a good idea what the product is (still) missing/having flaws of ...

SQL Server 2022 Keeps Getting Worse.

Check my little article "Logon monitoring in SQL Server and Azure Managed Instances - Adopting Extended Events"

Maybe it can get you started

First of all, don't use this construct of you can directly perform the delete from the "in-list-query"

DELETE RAL
FROM c_repos_applied_lock RAL
INNER JOIN c_repos_table RT
    ...

Thank you for the feedback.

As always, checking and double checking, stepping back to get a broader view what's going on and then working back to the issue is key!

did you also try to use just the group name (without the domain information) ?

On a single instance SQL Server 2022 installation, you can find bcp.exe overhere: "C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn"

With multiple instances, it may be needed to actually provide the correct path...

You can only define and use one port for mirroring and always on (combined ! )

What error are you receiving?

How large is your (test) table?

What about indexes?

Please post DDL

A trigger is always handled in the scope of one transaction.

Cascading triggers ( as you implemented ) are handled in the scope of the same transaction.

So to get around your...

Homework, school assignment, ... try chat gpt

enable query store and get a good view onto what is going on.