The bigger problem I just found out is that this column is part of the key structure on some of our financial tables.  So splitting it out makes it...

There are many articles covering "Composite columns" (/ "composite keys") vs individual columns (/ surrogate key ) pro's and cons.

You are now at a junction point handling one of the...

Did you notice you end up with a negative DurationInSeconds ?

--                ...

Please post the "Server Audit" and the "Server Audit Specification" scripts.

There must be some filtering active for it not to report all.

Did you enable as well the "Server Audit" as well as the "Server Audit Specification" ?

Check filters !!

I just export the plan and its consumption statistics from the plan cache.

1 file with all consumption details, 1 .sqlplan file per plan

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, 2 months ago by Johan Bijnens.
• This reply was modified 2 years, 2 months ago by Johan Bijnens.
• This reply was modified 2 years, 2 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
    ...