Jeff,

After extensive testing your solution is the best for our environment. Thank you very much for all the help.:)

Troy Doherty

Once again thank you for all the great replies.

Jeff, I have a sandbox hung off od our DEV environment so not risk to real data. 😀 I have a...

set @dt = getdate()-94 is Sep 18 2007 3:37PM

select @dt = datediff( d, -94, getdate()) is Mar 24 2008 12:00AM

By deleting records < select @dt = datediff( d, -94,...

Sorry Missed part of the table configuration.

CLUSTERED INDEX time_stamp, connid

INDEX connid, key1

I did a bit of testing and limited my purge to 6 records(we only have 6 records older than...

Steve, Jeff,

Thank you both for your quick replies. I will be trying a combination of your suggestions after the holidays. I'd hate to break something for Christmas. 😀

I prefer not...