Improve Stored Procedure Performance in SQL Server

sqlserver2014

These basic tips by Ahmad Osama help steer your database development to avoid common performance issues.

1. Use SET NOCOUNT ON

2. Use fully qualified procedure name

3. sp_executesql instead of Execute for dynamic queries

4. Using IF EXISTS AND SELECT

5. Avoid naming user stored procedure as sp_procedurename

6. Use set based queries wherever possible.

7. Keep transaction short and crisp

You can read the details for each tip at his article here.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s