Well, the server was set up and maintained by a guy who thinks we should migrate everything to MySQL, and every time I try to change stuff for good, he...

I added parameter sniffing to the SP (no need to look it up, just didn't remember it as an strategy to improve SPs...) and now it came back quicker than...

I agree, what I am doing is that today I run it but for yesterday and tomorrow it will run for today, that way I would pick up the entire...

Thank you Koen and Craig for your reply.

I will keep in mind Craig's advice, but based on the fact I have a deadline, I will go with passing the variable...

In the OLE Component.

I don´t use the query, just set it to "Use a table or a view" and pick the one from staging that is a copy of it.

Is there way I...

Thanks for your reply.

What I am trying to do is to load into staging only the new data from a table, I would load it all, but I am not...

I tried the four queries on a table that has 36k rows, using as parameter the amount of rows returned by the count(*) query, the fourth option is not accurate...

Thanks Kevin, I will try that.

I tried recompiling just the part of the SP that takes the long, but it decreased considerably the performance of the whole process, so I...

Hi All,

Thanks for your replies.

I tried checking on table fragmentation, despite there's some, this doesn't seem to be the issue.

I can't create different procedures, since this is an iterative procedure...

Thanks Gail 🙂 that helped me out

-Do you use link servers and join with many tables between database? no

-Have you got sql R2 on the server ? no

-What time are the index rebuilds jobs happening ?...

Thanks, I will try that out.

Nevermind, I was thinking on SQL Profiler.

Tried that... but then everything gets super slow. I run the trace on a server that we use for development, is in the same data center as the production server;...