It would be much easier to offer suggestions, at least for me, if you posted the RDL so we could look at what you have developed. Even a small...

Can you post the execution plan (.sqlplan, not just an image) and the query?

Looking again at the values you posted from the execution log there doesn't really seem to be...

Stefan Krzywicki (9/5/2013)

---

Yeah, I'd either have gotten...

Time for some begging. If any of you will be in the Boston area Monday, October, 28 and would be willing to speak at the Seacoast SQL User group...

Sean Lange (9/4/2013)

---

Well this post is my 10,000th point. I guess I have proved I too can waste lots of time answering forums posts instead of doing my actual job....

GilaMonster (9/3/2013)

---

I don't.

I have about 8 years experience developing and tuning SQL Server. 0...

For what it's worth I put my comments and vote in for the MCM. It's interesting because I was going to try to complete my MCSE:Data Platform for 2012...

T.Ashish (8/26/2013)

---

The index was recommended by optimizer.

The table itself is having 14 indexes. Earlier it was more then 25, but we removed some indexes that...

Sean Lange (8/26/2013)

---

I would recommend breaking this into batches of 10k rows or so. A single insert with 13 million rows is going to kill your logs. This is one...

Ha all the reports I've developed and I've never noticed the arrows to adjust parameter order. I've been right-clicking the report -> View Code and then manually moving parameters...

Can you post an example of what is happening?

Typically when something like this happens it is because there is an object that cause the report to flow onto the next...

Any backup product that uses Volume Shadow Copy Services (VSS) cause this to happen so that they can get a consistent backup. This blog post, http://sqlservertimes2.com/?p=816 mentions this for...

Might not be the best solution but I'd probably have a script task as second step (first step is the source) that sets the NULL/empty application name to the previous...

I'm not sure that there is a definitive answer to your question. When I'm tuning and considering adding an index or indexes I make sure I consider the application/database...

I'll probably attend just for this one. I would currently argue that you'd be better off leading...