Thanks for the replies

The issue is easily reproducible by opening 2 queries in SSMS and running in them something like the following:

Query 1

WAITFOR TIME '14:27'

INSERT INTO [dbo].[t_data_entities]

SELECT DISTINCT [t_import_file1].[Entity_Name]

FROM...