This problem disappeared for awhile, but we recently upgraded to SQL 2008 R2, and It's Baaaack.

There is absolutely no indication of any problem when running the stored procedure in SSIS....

I once worked with a customer that had a finite number of tapes that they used for their database backups:crazy:. Their database was big enough to have to use...

I'm surprised nobody has mentioned:

Slideware - Similar to vaporware, but works/exists only in Powerpoint presentations

I haven't had time to try rewriting the task and stored procedure into seperate tasks yet, but I did run this with SQL Profiler on. And of course, everything...

divyanth - It is a single stored procedure that executes the 7 steps I described above.

Leo - The tally table is used to create a date range, so yes, it...

Ok. Moved here http://www.sqlservercentral.com/Forums/Topic850733-65-1.aspx

I know this is an old topic, and it's been even longer since I did this type of tuning work, but I have a question about disk layout, especially in...

An example I have worked on that used the iterative approach did so purely for reasons of cash flow. The project was a £500K project in total but the company...

Samuel, it sounds to me like you're saying the conclusion I've come to:

Process control, and movement of data from source to destination - SSIS good

Data manipulation - SSIS bad,...

Ok SSIS veterans. Thanks for your answers so far. But please help a veteran software implementor (>20 years) to understand why using SSIS is a good thing for...

You're right. My apologies.

So, how do you recommend doing "code reviews"? Trust the author to remember everything that has changed, and point it out to you? :crazy:

Come on, give me a little credit. I mean: Ok, I find the database object I'm interested in in the XML. How do you find that same location...

Yes, but how do you get back to the proper position in the visual editor?

And I'll add a related question: How do you do a code review? If somebody...

In a case of "Just because you can do something doesn't mean you should do it"

Ok, my first test with two charts took 17 seconds, as previously mentioned. Second...

Sweet As! Just got a chance to run this in my database. What took 20 minutes previously just ran in 8 seconds :Wow: !

Thanks Wayne.