Thank you very much for your reply.

I was able to solve issue, it happened because of missed up single quotes locations.

Thanks for the tip you sent , i didn't know...

Thank you Gail, appreciate all the replies.

Regards

Nader

Wilfred van Dijk (4/10/2016)

---

You can change both MaxDOP and Cost Treshold without having to restart the instance.

Make sure you clear the current waitstats before evaluating the new settings( give...

GilaMonster (4/10/2016)

---

The only thing that CXPacket alone tells you is that queries are running in parallel. Nothing more.

Increasing Cost threshold (it's not measured in seconds) is a good idea....

Wilfred van Dijk (4/10/2016)

---

CXPACKET has to do with Parallellism, it's an indicator of inefficient parallellism. Parallellism is not bad, but is should only be used for queries which benefit.

There...

Some follow up on what you mentioned Hugo.

After removing the top 30 and now by taking a look at the index seek operation on episode table.

The actual number of rows...

Sergiy (4/3/2016)

---

nadersam (3/31/2016)

---

First i would like to thank you Curious and Hugo for the detailed reply.

I have updated statistics for both database for those 3 tables.

The view still taking 3...

Thank you very much Hugo for the very detailed reply, i think it's great even if i can't fix that query because i learned many things, i posted as an...

Hugo Kornelis (3/31/2016)

---

Hi Nader,

The plans you post actually have the same plan shape, so they do not explain the performance difference you are seeing.

However, I do see that the estimated...

But will that raise the time from 3 sec to 9 secs, i think the difference is big .

Is the estimated row count based on stats correct now?

Hugo Kornelis (3/31/2016)

---

Hi Nader,

and I suspect that you are suffering from the "Ascending Key Problem" - an issue where estimates are wrong because the assumption is that added data...

First i would like to thank you Curious and Hugo for the detailed reply.

I have updated statistics for both database for those 3 tables.

The view still taking 3 sec on...

yes you are right off course...

Thank you very much guys.

For the sake of testing i have created a test table and populated it with data and checked bytes received from server under client statistics then...

GilaMonster (3/29/2016)

---

An index key is limited to 900 bytes. If I'm indexing, then I know that it's safe to put a varchar(10) into an index key, but if that's varchar(8000),...