Peter,

how do you deal with referencial integrity, or don't you have any FK-references to that table? That's the reason why we couldn't apply partitioning and chose to copy/delete old data.

You could also select all the targeted EventIDs into a temp table (with a clustered index if you want to delete in order). That's important if you don't want to...

hi,

if you want to use a join in this case, be careful and define a unique primary key constraint on your temp table(heap!). Joins on heaps are potential inefficient operations.

ciao,

jack