How can improve Performance of stored procedure

• Keep database object name short ,meaningful and easy to remember
• Normalize data atleast upto 3rd form but not at the cost of query performance
• Do not use those column in the select statement which are not required. Never user select * statement.
•  Use primary key in the table to filter the data in where clause. Use execution plan to analyze the query
• Use SET NOCOUNT ON at the beginning of your stored procedures  This statement is used to stop the message, which shows the number of rows affected by SQL statement like INSERT, UPDATE and DELETE It will remove this extra overhead from the network.
• Use table variables instead of temporary tables.