Oleg,
Instead of deleting once every 2-3 weeks, you might consider defining a job on the server to delete your 'unused' rows everynight based on the appropriate conditions
Mark
>>>Hi all,
>>>Every 2-3 weeks I load 0.5-1.5 million rec into server table and delete "expired" records. I delete records from server table using BCP+Fox solution (DROP INDEX for all of them, BCP the whole table (3-5 mln rec) out, APPEND FROM tblOld.txt FOR myConditions to Fox table, COPY TO tblNew.txt, TRUNCATE server table, BCP in, CREATE INDEX ).
>>>It works good enough and using BCP+Fox I avoid transaction log nightmare that kills all SQL Server solutions I tried, but I am still interested in "Server only" solution and wondering how others deal with such problem.
>>>TIA and Happy New Year!
>>>Oleg
>>
>>Are the records being deleted coming only from the records you load every 2 to 3 weeks? If so, [at least in Oracle], you can use a BEFORE INSERT TRIGGER to prevent non-qualifying records from being inserted. Any other records already in the table would have to be deleted using the DELETE FROM command.
>
>No, I delete records that were inserted 3 months ago and were not used.
>Thanks
>Oleg
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only