Viewing 15 posts - 37,246 through 37,260 (of 39,511 total)
Have you checked the query plan?
An alternative is to "batch" the updates:
http://www.sqlservercentral.com/columnists/sjones/batching.asp
Steve Jones
July 2, 2002 at 12:59 pm
I agree with Brian in general. Coding on the fly leads you to forget things and make bad designs.
HOWEVER, I've been doing this a long time and a few things...
July 2, 2002 at 12:28 pm
If there are no indexes, it should insert in the same order, but SQL is not bound by this. Easiest way is to add a clustered index on the columns...
July 2, 2002 at 12:17 pm
How are you connecting? Are you a local admin?
Did you set an sa password? Are you using NT Auth or SQL Auth?
Steve Jones
July 2, 2002 at 12:13 pm
I created a sproc that creates a cursor from sp_who2 (or you can use sysprocesses) and kills each connection.
I usually run this before a restore a couple times. Some connections...
July 2, 2002 at 10:39 am
Similar to Andy. If it's something I've done, I'll probably just code.
If not, I'll probably outline some to be sure I won't forget anything and then fill in code. I...
July 2, 2002 at 10:35 am
The diff, I believe, flushes the logs, but I'm not sure. You'd ahve to test it and verify that you could restore (or not) using only the full and logs.
Steve...
July 2, 2002 at 10:33 am
No more overhead than using the connections in DTS. Some people prefer to code them in ActiveX rather than the connection. They may get more flexibility. These are resources on...
July 2, 2002 at 10:31 am
check the inserted and deleted tables
OR
change the app to perform the logging in a transaction with the update.
Steve Jones
July 2, 2002 at 10:26 am
I tend to format CASE using indents (tabs) for the different lines.
SELECT
case
when x = 1
...
July 2, 2002 at 10:19 am
Don't really see anything in Technet or BOL related to this.
How much memory on the server? Does available memory decrease? Does SQL memory increase?
Run profiler and verify if anything else...
July 2, 2002 at 10:13 am
You'd have to write some type of loop or some complicated SQL to get this. Not sure how to remove the pub_id from the duplicate lines.
Steve Jones
July 2, 2002 at 10:08 am
EM will drop and create the table for you. Check the script if you want to learn how this works.
Steve Jones
July 2, 2002 at 10:02 am
Viewing 15 posts - 37,246 through 37,260 (of 39,511 total)