@lutz: thank u for ur valuable tip...:-)

@gila:I have already read ur articles..really nice..I ll read it again for better understanding.:-)

clear..:-D

I hav lot of doubts..so shall i start a new thread for each doubt?

I have already read this article and also lots related to it.

I want to know what do you guys(sql server experts) do when you are asked to tune a stored...

sorry i am a beginner so it takes time for me to understand it.

another question

what are all the basic things i need to check up for tuning any stored procedure?

what is the conclusion guys?

ok

hmm

actually i posted it in different forum..but i didnt get a reply..dats y posted here.

thank u ..simple and clear explanation.

consider this,

Original query

update workmgmtplan with(rowlock) set IsWebPlannerTracked=1 where planid=@WMPID

update workmgmtplan with(rowlock) set IsWebPlannerTracked=1 where planid in

(select workmgmtplanid from workmgmtlinkedplans with(nolock) where linkedworkmgmtplanid=@WMPID)

update...

thank u so much..

am clear now..

consider this,

Original query

update workmgmtplan with(rowlock) set IsWebPlannerTracked=1 where planid=@WMPID ...

thank u..:)

@gila: i hav seen queries like" if exists ( select 'x' from tablename)" actaully i meant this query only.