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...
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL