Thank you very much.

Yep. I did went with indexed views and going well so far.

Thanks for responding even on older thread. I appreciate it.

Lynn -

I do not report to Director. The reason I posted here because I wanted to check how to deal with people in a such a big role when requests...

Evil Kraig F -

Well, that would be my first guess when this happens. Just a double check, you're using the same parameters as the call in the trace,...

I really appreciate your time on this Gilamonster.

I will get back with my findings.

please find the attached scripts.

Ok Sure.

Do you want to see complete result set from sp_help for table defination?

How do you want me to get index defination?

I mean do you need something like this for...

First of all, thanks for your time in helping to solve this issue.

I have formatted code as mentionted by bill and I was able to get actual execution plan by...

Gila- Will row counts from all tables involved in the query will do ?

Thanks Gila.

I have attached the the sqlplan.

FYI. The attached plan is estimated plan not actual.

Thanks Jones.

Thanks.

I followed the Easy method but I dont see any article with status in (0,8) all of them were 57.

Thanks,

Kiran

sorry all the trans are in distributor but not replicating fast to subscriber.

Is there any settings I need to change to make it fast ?

Thankyou Folks.

are you doing full restore?