Hello. We are using SQL SErver 2000.
We are moving appending data from one table to another table. Many millions of records.
We don't have alot of extra log space. How would I do this without it writing to the log files?
`LeYou can't turn off loging completley. Or at least in 2k you couldn't years ago my boss insisted you could and I hounded MS for proof that there was no way to completley shut it off.
I don't know how you are getting this data in but perhaps a combination of set implicit transactions on, and commits after a specific number of rows would be of help. I do a lot of this in Oracle.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment