Stored Procedure Optimization Tips – Best Practices

added by pinaldave
2/18/2010 12:45:06 AM

23 Kicks, 921 Views

Key Points discussed in the articles are : 1. Include SET NOCOUNT ON statement 2. Use schema name with object name 3. Do not use the prefix “sp_” in the stored procedure name 4. Use IF EXISTS (SELECT 1) instead of (SELECT *) 5. Try to avoid using SQL Server cursors whenever possible 6. Keep the Transaction as short as possible 7. Use TRY-Catch for error handling


2 comments

pinaldave
2/18/2010 1:59:32 AM
Thanks for wonderful comments on blog.

pinaldave
2/18/2010 10:17:32 AM
I strongly encourage all of you who visit original link to read the comments and enrich the article with additional input.

Kind Regards,
Pinal