Thanks Johan,

I couldn't possibly take offence where people are actually trying to help me.

I'll keep you posted.

Regards

Steve

Sorry - I did say in my first post about the partition - just reading about the sliding window now

Thanks folks,

Just to be clear, the delete is not about reclaiming space, it's about removing data to keep a manageable amount online for reporting The table has about 330M rows...

Thanks for that response,

I think that I've attached the execution plan

Kind Regards

Steve

OK,

I added a datefield and retro-populated exisiting records with the date from the parent record.

I also modified the data-loading app so that new records are populated with the date.

The good...

OK, I can add a date into the row, and I will see how that goes.

I figured that looking at an INT when deleting would be more efficient than working...

sorry should have added that the loop is to catch those months where there are more than 28 days

Thanks for replying.

The table is:

[id] [bigint] IDENTITY(1,1) NOT NULL,

[PostCode] [varchar](8) NULL,

[DeliveryPoint] [varchar](2) NULL,

[Quantity] [int] NULL,

[css_session_id] [int] NOT NULL,

[day] [int] NULL,

[month] [int] NULL

The only key is the css_session_id which is used...

Thanks folks,

The problem was indeed down to the fact that different connection types using different naming and referencing for parameters.

I've changed the connection to ADO.NET so that the naming and...