Posted by Jack Vamvas on 03/17/06 18:02

Without knowing the query access during this time it's hard to say, but
another idea
is you can create a Temporary Table (a persistent backup table with all the
date , not a sql temp table) and move the records there. (the ones you want
to keep)
Truncate your parent table. And move the records back to the original table
with the records you want.
Do the tables have clustered indexes?


--
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
<hallpa1@yahoo.com> wrote in message
news:1142610809.679117.5620@p10g2000cwp.googlegroups.com...
> I understand that the tables are accessed frequently during the day. I
> know that I have to be very sensitive to affecting the response times
> of queries against these tables. I am not the DBA that owns this
> database, so I do not have access to specific details about the queries
> against the tables.
>

[Back to original message]