Why is this left join used in your "WHERE NOT EXISTS " parts?

            ...

Why is this left join used in your "WHERE NOT EXISTS " parts?

              ...

indeed. Good point.

Keep in mind, your LOG file(s) may not shrink at first attempt !!!

ref Shrink a log file

can you post your indexes create statement ?

Check out TSQL Restore Database, and you'll find you can to specify new locations for all files making the database

Just add "move .." for the location of the concerned...

• This reply was modified 3 years, 1 months ago by Johan Bijnens.
• This reply was modified 3 years, 1 months ago by Johan Bijnens.

have a look at "Logon monitoring in SQL Server and Azure Managed Instances - Adopting Extended Events"

There should indeed be performance related advantages when using #temp objects.

According to your use case, an index on a #temp object may indeed help out.

performance  - performance - performance -...

What I "love" about these scrum sprint agile and the newer cicd developments is that most managers think it will speed up their sloppy work.

They still don't have a clue...

I add an extra jobstep to check the db role!

This step will quit reporting success when the raiserror is executed !

It will proceed to the next step if this step...

Once you actually get it that you need to work with OFFSET instead of pointers, handling bitwise operations will start working.

I always have such problems when I'm in the US...

Have you ever investigated MS Query Tuning Assistant  ?

It will avoind storing every sqlplan in the plan cache.

Queries that run only once do not polute your plan cache when this setting is on.

The article below holds all information:

ref:...

Did you enable contained db authentication at instance level?

exec sp_configure 'show advanced', 1
GO
RECONFIGURE
GO
exec sp_configure 'contained database authentication', 1;  
GO  
RECONFIGURE;  
GO

( edited: added...

• This reply was modified 3 years, 1 months ago by Johan Bijnens.

This version also handles most cross database queries:

SET NOCOUNT ON;

IF OBJECT_ID('tempdb.dbo.#invalid_db_objects') IS NOT NULL
BEGIN
    DROP TABLE #invalid_db_objects;
END;

CREATE TABLE #invalid_db_objects
     ...