Matt Miller (2/2/2009)

---

Lynn Pettis (2/2/2009)

---

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

latingntlman (2/2/2009)

---

Thanks, that worked.

Another question:

I'm trying to add a Data Flow step to my package thru BI Studio, but can't seem to find the equivalent of sql 2000 Server Enterprise...

GilaMonster (2/2/2009)

---

idrees.butt (2/2/2009)

Sure....

Please take the time to read the first article linked in my signature block below regarding asking for assistance. Follow the guidelines in that article and post your table...

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...