Yes, in theory could be less efficient in some cases than a LOOP join.  But it's still reasonable performance.  You'll never totally drop off a performance cliff going from LOOP...

First let's correct the PK.  Then the code for the proc.

ALTER TABLE [dbo].[Contracte] DROP CONSTRAINT [PK_Contracte];
ALTER TABLE [dbo].[Contracte] ADD CONSTRAINT [PK_Contracte] 
    PRIMARY KEY...

If it could ever have more than one, then it needs to be a JOIN, just like you have it.

Yeah, seems like a bug in SQL optimizer.  I'd make sure SQL didn't use a LOOP join (gack!) for the two main tables.  I think the hint will also force...

You're welcome!

The source table, DBSource.dbo.Contacts, must have duplicate entries for the same ContactID.

Yes, a standard Agent Alert, like below, but you need to change <instance name> to your actual instance name and the job id to your actual job id:

            
April 9, 2021 at 8:41 pm
            
#3867407

            
            
                                                
        

Overhead.  The default health trace contains deadlock info, although I prefer to create my own extended event specifically for deadlocks.

I have an alert that triggers a job when a deadlock...

There is a T-SQL forum.  This type of q would generally go there.  But not a real problem.  Try the code below:

SELECT pf.Name, 
   ...

on...

(1) Yes.

(2) It means to any recoverable resource, that is, any resource affected by COMMIT / ROLLBACK.

(3) Data in memory (in a buffer) that is forcibly written to disk is...

First, need to number these qs:

(1) With WAL - Any modifications are written to the transaction log before they're written to the data files (mdf). Is this correct?

Most articles...

I'm not getting any syntax errors on:

ALTER DATABASE [IBMStemplate] SET ANSI_NULL_DEFAULT OFF

Not sure what that's about.

Btw, I just noticed that you're growing the log file by 10%.  NEVER use %,...

https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008/dd894051(v=sql.100)

"

Compressed pages are persisted as compressed on disk and stay compressed when read into memory. Data is decompressed (not the entire page, but only the data values of interest) when...

We have dedicated Sr. People for optimization and they have been doing it for more than a decade for some good clients. So we trust their...