24 Kicks

Stored Procedure Optimization Tips – Best Practices(blog.sqlauthority.com)

submitted by pinaldavepinaldave(9662) 2 years, 3 months ago

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 |category: |Views: 779

tags: another

new Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

  • "Kick It" text
  • "Kick It" background
  • kick count text
  • kick count background
  • border

Simply copy and paste this HTML into your blog post.


Users who kicked this story:
moeen49moeen49(0) - dyardydyardy(199) - zorro2006zorro2006(10) - jeetjeet(0)
More who kicked this story...
Comments:

posted by pinaldavepinaldave(9662) 2 years, 3 months ago 0

Thanks for wonderful comments on blog.

Reply

posted by pinaldavepinaldave(9662) 2 years, 3 months ago 0

I strongly encourage all of you who visit original link to read the comments and enrich the article with additional input.

Kind Regards,
Pinal

Reply

information Login or create an account to comment on this story
Submit a Story
View upcoming stories
How else can I help?
Add our feeds to your site

Most Active Users

What's this?