There are many tips and tricks for the same.

• Include SET NOCOUNT ON statement.
• Use the schema name with the object name.
• Do not use the prefix "sp_" in the stored procedure name.
• Use IF EXISTS (SELECT 1) instead of (SELECT *).
• Use the sp_executesql stored procedure instead of the EXECUTE statement for Dynamic SQLs.
• Try to avoid using SQL Server cursors whenever possible.
• Keep the Transaction as short as possible.
• Use TRY-Catch for error handling.
• Optimize queries and fine-tune indexes.
• Use table variables and temp tables appropriately.