Viewing 15 posts - 1 through 15 (of 25 total)
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...
January 29, 2013 at 11:44 am
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...
January 29, 2013 at 10:09 am
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...
August 29, 2012 at 1:15 pm
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...
August 28, 2012 at 3:45 pm
In the OLE Component.
August 28, 2012 at 2:49 pm
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...
August 28, 2012 at 2:17 pm
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...
August 27, 2012 at 10:04 am
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...
October 19, 2010 at 6:53 am
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...
October 14, 2010 at 8:23 am
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...
October 13, 2010 at 9:24 am
Thanks Gail 🙂 that helped me out
September 28, 2010 at 3:01 pm
-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 ?...
September 1, 2010 at 8:00 am
Thanks, I will try that out.
August 31, 2010 at 10:33 pm
Nevermind, I was thinking on SQL Profiler.
August 31, 2010 at 2:50 pm
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;...
August 31, 2010 at 2:49 pm