Hi Gail..

Here is the attached actual execution plan.

Thanks again for helping me. what are the main thing to consider in the query execution plan. ?

sometimes I see that there is...

SQLGURU.. so you are saying that I should hire a person in my company to troubleshoot the issue or you will help me by charging money. Is that right.

Sure, that will be great if you send me some kind of document which will trouble shoot the performance issue.

Wow, I put maxdop 4 and hash join and the query return in less than five minute. Guys you are great.

You really deserve for big award.

Guru is the...

There are scans but cost is 0%, do you think we should consider those too. I am sending you the same query plan which I am looking at right now.

DN100...

Thanks GilaMonster for taking so much of pain to solving this query.

Attached is the table and index defination.

I cannot do the Acutal execution paln because this query never finishes or...

SQL Guru.. I know this query is not good for optimizer so I did modify and used in a following manner but still going in a suspended mode and the...

Attached is the query plan.

I have a processor from 0 to 7.means 8 processor and the minimum server memory is 24000 mb and maximum memory is 28000 mb

I am not...

Scott.. I ran the query you provided me and got the result. How value I should look for and do what.

Here are the important values.

Status : suspended

wait_type : CXPACKET

wait time...

The first query which is creating the problem. I checked the query plan and iit's taking index seek.

How to attached showplan in the reply.?

Here is more information about the query.

STATUS : SUSPENDED

WAIT TYPE : CXPACKET

WAIT CATEGORY : PARALLELISM

#OF WAITERS : 2

% WAIT TIME 100%

I tried option maxdop = 1 but no luck.

Here is...

I try giving DENY VIEW DEFINITION at the database level and having the same issue.

Sure, I will do that.

There was a DDL trigger on that database and I deleted that trigger and ran the code as a stored procedure and it's working fine. You guys rock. Thanks a...

Now, I ran the code which Jeff has provided. It's working fine when I run as a select command but when I try to convert into a stored procedure I...