Help!How to speed up query by not writing to Transaction log

Article View: bit.databases.mssql-l

Article #236

Back to bit.databases.mssql-l Previous Next

#236

From: JK
Date: Mon, 13 Sep 1999 00:00

9 lines
1085 bytes

I am writing sql queries to pull in data. The transaction 
log gets filled and slows my code. I tried bulk/copy
option on, but it does not help. Any help will be
greatly appreciated. Thanks.

JK

* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
The fastest and easiest way to search and participate in Usenet - Free!

Technical Details

Message-ID: <0a288596.7a870e3b@usw-ex0103-020.remarq.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f6611,fcaa8871be6ea625,start
X-Google-Attributes: gidf6611,public
From: JK <jeelanikNOkeSPAM@hotmail.com>
Subject: Help!How to speed up query by not writing to Transaction log
Date: 1999/09/13
Message-ID: <0a288596.7a870e3b@usw-ex0103-020.remarq.com>
X-Deja-AN: 524681333
Bytes: 350
X-Originating-Host: 4.16.62.18
X-Complaints-To: wrenabuse@remarq.com
X-Trace: WReNphoon3 937266355 10.0.2.20 (Mon, 13 Sep 1999 16:45:55 PDT)
Organization: http://www.remarq.com: The World's Usenet/Discussions Start Here
NNTP-Posting-Date: Mon, 13 Sep 1999 16:45:55 PDT
X-Wren-Trace: eIKnj46X0JrRyJOPi8ONgpuxmoiTi8Odi8COjobWz4zc0ozV3ozG1A==
Newsgroups: bit.databases.mssql-l