Viewing 4 posts - 1 through 4 (of 4 total)
steveb. (7/9/2011)
dhearne 25776 (7/9/2011)
These two things make the logging of the operations unnecessary overhead.deletes are still logged in simple mode, as are all the transactions.
The point...
July 9, 2011 at 4:53 pm
This is inaccurate due to a specific scenario, and that scenario is called the log chain. If you place a database into simple mode, from that moment on you...
July 9, 2011 at 8:27 am
Phil Melling (7/1/2011)
3) If possible, put the database into SIMPLE backup mode so that the deletes are not logged. (Make SURE to switch it back afterwards!)
No! Don't put it...
July 1, 2011 at 8:44 am
Some tips:
1) Do it in chunks
2) Commit frequently (after each chunk). That way, if you have to cancel, it doesn't roll back the entire transaction.
3) If possible, put the...
July 1, 2011 at 6:51 am
Viewing 4 posts - 1 through 4 (of 4 total)