It is an option, but you may end up being deadlocked most of the time, depending the amount of blocking and lock escallation

Scalar functions are still  a big NoNO ! ( Inlining doesn't work on all SVFs !! )

Write your SVFs as InlineTableValueFunctions and things will perform again

Have you checked SQL Server audit data?

/*
Generate Server Audit event session to trace action in a database

DBA_ServerAudit

*/

Declare @CreateSession bit = 0;

Declare @DropSession bit = 0 ;

Declare @StartSession...

• This reply was modified 2 years, 10 months ago by Johan Bijnens.
• This reply was modified 2 years, 10 months ago by Johan Bijnens.
• This reply was modified 2 years, 10 months ago by Johan Bijnens.

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