Is there any way of avoiding writing to the transaction log during insert
and things like that. I am running a VB applciaiton and when I call a store
procedure it takes forever to finish. I figure if I am able to avoid writing
to the transaction log it will be faster. Thanks.
Re: Transaction log
As far as I have ever heard, there is no way to turn off logging, apart from
bcp or "insert into" operations...
The following article applies to all versions of SQL server from 4 - 7, and
I would assume for 8 as well...
However, there are usually better ways to tune your SQL that by this type
of step. If you post it here, we may be able to make some suggestions...
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center