stored procedure performance

Question

how to Improving Stored Procedure performance?

Ramesh Palanivel · Accepted Answer

Hi Hemanth,   Use Normalization,  Avoid executing multiple queries, instead of that store all the query in string variable and finally execute once, Use some advanced methods as per your requirement like Cursor,Indexer,Pivot,etc

Faisal Pathan · Answer

Follow below steps:   1. sp_executesql instead of Execute for dynamic queries 2. Using IF EXISTS AND SELECT 3. Keep transaction short and crisp 4. Use SET NOCOUNT ON 5.Use fully qualified procedure name