ok now it works. I was misunderstanding my own problem.

Thanks for your time. 🙂

The

[ScanDateTime] [datetime] NOT NULL DEFAULT (getdate())

will actually get the current date, not the CreationDateTime.

I think this problem needs a trigger. I do not see how it can be resolved in...

At the end would be ok. It doesn't matter.

CREATE TABLE [dbo].[ItemLocationHistory](

[IdItemLocationHistory] [uniqueidentifier] NOT NULL,

[IdItemLocation] [int] NOT NULL,

[BarCode] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AI NOT NULL,

[IdItem] [int] NULL,

[CreationDateTime] [datetime] NOT NULL CONSTRAINT [DF__ItemLocat__Creat__093F5D4E] DEFAULT (getdate()),

[IdActor] [int] NULL,

[IdDriver] [int] NULL,

[Model] [varchar](30) COLLATE...

Thank you CirquedeSQLeil,

The article you gave me is exactly what I was looking for. The guy who wrote the query with the 'cast(...' was trying to strip the time part...

Hi Jack,

thanks for your suggestions. I am currently implementing them.

This is a query that someone else designed some months ago and I was assigned the task to make it run...

Hi Jack,

thank you for you reply. I attached the two execution plans in graphical format.

I updated the statistics before getting the plan of the slow database but it changed nothing.