Truncate or Rebuild Tables?
I frequently have tables that I want to empty and refill. I thought I read somewhere that trucating was a bad idea, example:
Truncate table tblFruits
A bad idea because of something to do with the log? I'm a beginner so I don't understand transaction processing very well, or logs.
Is it better to delete the table and rebuild it in code before you add the values?
Truncate or Rebuild Tables? (reply)
We truncate a couple of our tables at the end of each night and have never experienced problems so far. Our transaction logs haven't grown to a huge size but then we do dump the transaction log every night as well.
------------
Tommy at 3/8/01 5:32:57 PM
I frequently have tables that I want to empty and refill. I thought I read somewhere that trucating was a bad idea, example:
Truncate table tblFruits
A bad idea because of something to do with the log? I'm a beginner so I don't understand transaction processing very well, or logs.
Is it better to delete the table and rebuild it in code before you add the values?