just created a login and tried it. It gave some good layman explaination. Once thing, I wanted to ask,...

what else is the code doing e.g. the full code of sp_crm_lead_account_matching?

Your call has other parameters and you are using output variables that are not used on the query you...

without even knowing which CRM vendor this is I would suggest the following

• change CTFT to 50 - default of 5 is normally way wrong.
• speak with the vendor and...

will this give you what you need? https://www.sqlservercentral.com/scripts/script-db-level-permissions-v4-3

Intellisense telling you it thinks there is an error isn't the same as having an error.

so do you GET an error when you execute the code?

does the index not get...

recommendation from microsoft is CU - so go that route

https://learn.microsoft.com/en-us/archive/blogs/sqlreleaseservices/announcing-updates-to-the-sql-server-incremental-servicing-model-ism

something along these lines - it assumes that none of the duplicates already contain a row that is 1 hour ahead

if object_id('tempdb..#keys') is not null
  ...

if the proc is running then using sp_whoisactive MAY give you the current explain plan - to got it the command would be

exec sp_whoisactive @get_plans = 1 -- or =...

you need to install IBM's odbc driver for I series - see https://www.ibm.com/docs/en/i/7.2?topic=oa-set-up-your-system-i-access-odbc-driver

with it you can use SSIS or C#/Powershell to connect to your as400 and then load data onto...

Ring knocker here. I have 25+ years of SQL Server experience, you should listen to what I have to say. 😉

One a personal note, continuous learner here as there...

and speaking of blocking.

whoever did the code does not really understand what "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;" and "with (nolock)" do.

apart from the fact that it allows you to...

I've just looked at one of our processes - a 16 Million rows file, 5.5GB in size, 50 columns (mix of char, date, ints) - loading from a NAS share...

7 hours for 7GB... they definitely doing something wrong (like...

splitting the file should be last resource after you try out the remaining options.

• how many rows on file
• spec of server where SSIS runs
• spec of destination SQL server...

following "works" - but see comments

select t.objid
     --, t.COMMENT 
     , times.*
     , team.chg_ass_team
 ...