Ways to improve performance of stored procedures

• Use SET NOCOUNT ON to reduce network traffic

• Avoid using SELECT *

• Use table variables instead of temporary tables

• Avoid using cursors

• Use appropriate indexe...read more