karthikeyan (8/20/2008)
Andras,t would probably be a poor choice if you do not want to get rid of every row in your table.
You mean we need to use TRUNCATE if we dont want the log for those deleted records.
Am i correct ?
...
Hi Karthik,
Basically yes, when you can use TRUNCATE, it is a good way to empty the whole table, and the individual row deletes will not be in the transaction log, so it will be fast. But TRUNCATE deletes all the rows, and this is the reason it may be less applicable to the OP (assuming I understood the question right).
Regards,
Andras