Charles Kincaid (1/5/2015)

---

Check with the SMTP servers administrator. I noticed that your FROM address is not the same domain name as the SMTP server that you show. As...

No, nothing fancy. Just word "test" in subject and body. Relaying by they...

Yes, everything is working. I installed Windows Mail on the server and configured with the same settings as...

Hello,

Please see attachments.

Query being produced by some entity framework at front-end, it's not part of SP or manually coded query, so let's move away from bashing how bad query is and think...

ChrisM@Work (9/10/2014)

---

artisticcheese (9/9/2014)

---

Still don't get it. If it will choke on it then I would assume no results will be returned, instead exactly 88 rows returned and then it hangs...

Still don't get it. If it will choke on it then I would assume no results will be returned, instead exactly 88 rows returned and then it hangs with high...

I can not rewrite the query since this query is code generated from third party packaged application. I can created indexes/update statistics etc but not much abount actual code with...

I narrowed down the issue to statistics, updating statistics on 3 tables used in quyery query complete immediately. No index rebuild necessary.

Estimated execution plan before statistics was updated and actual...

I know it hangs on row 88 becouse that's the last row I see in output. Output appears exactly 3 seconds (like first query is finished) and quickly shows all...

Yes, that's all I did and yes I believe it's not performance/unoptimized queries issue.

If it would be any of those then results would eventually come up and it would not...

Yes, it DOES hangs indefinetely with high CPU. I waited for 30 minutes for results to come back which stayed on row 88 all this time. Again we are talking...

I know about unoptimized quires, indexes missing etc. This is NOT perfomance issue though, it's high CPU hang issue (like you see if you have code loop). Engine stops at...

I don't understand how this can be an explanation since there are no errors being produced and results are always hanging exactly at the same spot (row 88 out of...