Can we get the original query and some sample data?

Are you moving very large BLOB data around? Seen this before...

Personally I am not a fan of SELECT...INTO. You...

Jeff Moden (11/23/2010)

---

Gangadhara MS (11/21/2010)

---

Dear Experts,

We are having performance issues on production server.

The following task i have carried out and i need your suggestion further.

1.I have used profiler to...

😉 I was...

do your research on 64bit systems carefully! 64bit systems require more memory for the OS. I believe its along the lines of 5GBs to the OS.

my guess is MSPAINT.exe

grahamc (11/23/2010)

---

a_ud (11/23/2010)

---

Being @sql a NVARCHAR(2000), and @nameDB a VARCHAR(50), I'm trying to run these dynamic SQL commands (copy pasted):

SET @sql='INSERT INTO @EventList

...

nail in the coffin, SSRS hands down...

GilaMonster (11/23/2010)

---

Same here. Plus I neither have the time nor the...

a_ud (11/23/2010)

---

Being @sql a NVARCHAR(2000), and @nameDB a VARCHAR(50), I'm trying to run these dynamic SQL commands (copy pasted):

SET @sql='INSERT INTO @EventList

...

churlbut (11/23/2010)

---

My vote is with Da-Zero. Dynamic SQL in Execute SQL tasks. I think these run more efficiently than Data Flow tasks, especially if you will be working...

Ninja's_RGR'us (11/23/2010)

---

GilaMonster (11/23/2010)

---

Brandie Tarvin (11/23/2010)

---

Only ever use Dynamic SQL when you absolutely have to because dynamic SQL can't cache any execution plans for re-use later, which is a performance hit...

GilaMonster (11/23/2010)

---

Agreed. Often just a few days from someone who really knows their way around tuning procs can make all the difference. Plus there's...

Like this?

INSERT INTO x

(

...

)

SELECT ...

FROM y

... = column names 😀

...

Only ever use Dynamic SQL when you absolutely have to because dynamic SQL can't cache any execution plans for re-use later, which is a performance hit (I hope Gail will...

there are a number of ways to get data out to a CSV...

In SSIS you can:

1. In the data flow, delete the existing flat file destination and connection manager,...