Is there a way to check execution plan for sproc while running it from Application ??? I've done it only from query analyzer.

Yes, ANSI settings are same. I have taken the same parameters as used by application. Right now trying to go into the right direction.

Gail, I just went through details and through some good articles. Was able to interpret informaiton now.

Thanks Mohammmed for the link. It's real good.

Isn't it possible to use more than one condition inside if exists() ?

As per my standards, the best execution plan should look like when you can see the 100% Index seek from a table (within a query). So try to check other...

Hello Sir, its not like I didn't give it a try. I read a lot and tried lotz of options and tested them as well. However whatever I have tested...

Yeah. By normalizing the sprocs I meant just the functionality of normalization.

Understood. It means as per thumb rule, the funtionality of a sproc should be as specific as possible and we should try to normalize the sproc as well.

Well, it depends on a person's perspective (I feel :)). However my point is whether its good to have three different sprocs for three processes or one sproc for all...

My question is simple. Is it better to have single big sproc having functionalities for all the parts of a module or should i break it up into three different...

Gila, But i think that would be pretty good idea to do future forecasting for performance. Analyzing those execution plans can tell a lot of story.

Any alternative ways to do...

I read somewhere that we can perform the stress testing by playing with table's statistics. Does anyone know about that ?

Great. Thanks, that helped.

Your message doesnot shows anything....

No No. I just need one record per Team Id. The one with latest Orderdate. Consider there are lots of Teams with hundrds of OrderDates.