Hi,

You'll have to give us a bit more information than that sorry.

Is all the data in the same table or is distributed amongst a few tables? Either way, have...

Thanks for the response Adiga.

HowardW (10/25/2010)

---

Are both CPU time and elapsed time lower on Procedure B? If it's just elapsed time, it could be generating a parallel execution plan for Procedure B, which although...

Hey,

No you weren't being agressive, honestly.

I've got it working now, the BCP is by far the fastest method, in the SSIS (passing it to a variable and then writing that...

Hi,

Sorry I'd not...

Hi,

Thanks for the reply, I'm now getting the file to write out correctly.

However the time it takes to run the query and pass this to the string variable is quite...

Ignore that sorry, I'd not set up the variable mapping correctly.

All works a treat now.

Many thanks,

Nic

Hi again,

The only issue I have now, is that my object variable (used for the loop container) contains a UID for each row of data, how do I get his...

Many thanks,

I'll have a read of it now.

Nic

I would have a read of this

http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing

It's...

Could it be down to parameter sniffing, I know the optimizer behaves differently with local variables.

Can you see difference in the actual execution plans?

Yeah I experienced something similar last week, I should of really identified it as that...

Hi Markus,

Thanks for the reply, I think your right and it could just be the optimizer getting in a state with the values I provided, I will try some other...

Hi all,

Thanks for the feedback, and sorry for not getting back sooner, I'm going to give the recompile a try, just to prove if it's a sniffing issue or not.

Also...

Hi,

Thanks for the links on parameter sniffing, having a read through them now, I'm fairly sure that this is our issue, although I wonder why the issue has just raised...