-
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|