i was going to try this, but i don't think it will work very well with a non-clustered PK that is an identity column. and how long is the insert into the lookup table take compared to just deleting the data without referencing the lookup table?

i was going to try it on a table with 100 million rows where i always delete data that is over 30 days old. populating the lookup table seems to be a problem. the data is log data from different servers.