Typical geek, can't stay away. I should know, I do the same thing here, even when away I check on things.

rbarrera (2/2/2009)

---

I need some help with a sql script that basically goes like this:

USE DATABASE [YOURDB] DELETE FROM YOURTABLE WHERE COLUMNNAME = mytextfilelist.txt

and here I have a text file...

Confused I am. Your original question stated that developers currently run multiple windows resulting in the CPU jumping to 100%. If they serialize those updates, it should help.

update dbo.table1 set

col1 = some_value;

update dbo.table2 set

col1 = another_value;

update dbo.table3 set

col1 = and-another_value;

The three updates above will run...

Mike Levan (2/2/2009)

---

Another performance question.

Developers run updates queries on multiple databases at once, like if they need to update 3 databases they open 3 windows and run the queries simultaneously...

I agree with Jeff. Same thing with emails. Last employer I worked at people would send an email with error details in the subject line to the help...

Mike Levan (2/2/2009)

---

Lynn

the batch processing trick worked well with me and asavd lot of time. thank you. From your query does the @@rowcount gives the number records updated, do u...

alim.shaikh (1/31/2009)

---

hi frnd,

I think first n foremost thing u need is to have proper indexes in place.

I want to know which sql server u r using. it is a very...

Does this mean your problem has been solved?

Amazing how many problems seem to be solved using the running totals approach at times. 🙂

Jeff Moden (1/30/2009)

---

Oh, I absolutely agree... when someone said that SSC would have 10-15 million members in 5-10 years, I made the correction that it would have 200 users and...

longobardia (1/30/2009)

---

Hey There,

Pretty nifty query. It actually works if you change the following:

group by

tT.employeeid,

tT.TranDte

having

max(ah.updatedate) <= TranDte

)

If you run...

Here is the code I was working with. Please see if any of it helps you out.

Edit: For some reason, I can't cut and paste code from SSMS...

Also, I don't have an employee table or sample data. We could use that as well to help you with your query.

Be sure to include any indexes that are...

I'm not adding any data to your sample data provided. I don't fully understand your business rules and would prefer you add the data and provide the expected results...