SP Optimization

Hi friends,

Is any tutorial or useful link for stored procedure optimization with example.

I searched in google.But it is not enough. Please if you know send me,

Hope your’s reply.

Thanks & Regards