Here is a potential problem. This join is good in most cases, but not if you use MARS (Multiple Active...

ELLEN-610393 (10/17/2013)I have wondered if maybe there is a bad join in one of the queries. If you have time and are willing, I could post the two queries...

Erland Sommarskog (10/15/2013)

---

You ceartinly have a parallel query - all those execution context is a sure sign of that. I am surprised that there are so many workers per execution...

dwilliscp (10/16/2013)

---

So if you have one SPID, but 700 rows, that means the server is trying to do parallel processing? They all show CXPacket.. So how do I track down...

Truncating the table and reloading is not defensible in the long run. Your best option is to investigate time with the Progress application to find out how you can find...

If imports are taking that long, maybe you should consider incremental loads, rather than truncating and reloading? This may require logic to detect change, and it may require changes in...

Jeff Moden (10/15/2013)Perhaps I'm using the wrong words but I have to disagree. I don't have many examples but if you have a connection leak, for example, when using...

ELLEN-610393 (10/15/2013)

---

What I am seeing is thousands of threads for the same spid/session id [not an app that spun up thousands of spids]. Also what is showing is that while...

ELLEN-610393 (10/3/2013)

---

I see that you said that the default 0 for worker threads should be good. What is the impact of having a process spin up several thousand worker...

So that is the problem: you are using the UI, instead of using T-SQL commands directly. At very least if you use the UI, and things don't work out, you...

I am travelling, and don't have the time to research this further. Anyone else who can step in?

Again, since you are...

A small addiiton in case it was not clear: add that colimn as a computed column to the able and index it. That saves some space over adding it as...

Jeff Moden (9/22/2013)

---

Actually, I had to test it, and that was a good thing, because I had...

Jpotucek (9/22/2013)I guess my question was a little confusing. What I am unclear about is when you install SSAS and SSRS on a separate servers (separate from where your...