SqlServerKudos

Welcome!

SqlServerKudos is a place where you can find the latest SQL Server stories and articles to improve your skills and share your opinions.

Enjoy participating in this community and see which others are getting Kudos.

faq »

1
kudos

Kudos

SQL SERVER – Stored Procedure Optimization Tips – Best Practices « Journey to SQL Authority with Pinal Dave

published 710 days, 8 hours, 45 minutes ago posted by

pinaldave 720 days, 5 hours, 16 minutes ago

SQL SERVER – Stored Procedure Optimization Tips – Best Practices « Journey to SQL Authority with Pinal Dave

We will go over how to optimize Stored Procedure with making simple changes in the code. Please note there are many more other tips, which we will cover in future articles.

Include SET NOCOUNT ON statement: With every SELECT and DML statement, the SQL server returns a message that indicates the number of affected rows by that statement. This information is mostly helpful in debugging the code, but it is useless after that. By setting SET NOCOUNT ON, we can disable the feature of returning this extra i...

category: Query | clicked: 2 | | source: blog.sqlauthority.com | show counter code

tags: database, pinaldave, SQL, SQLAuthority, SQLServer

Border color:

Kudos Backcolor:

Kudos Forecolor:

Count Backcolor:

Count Forecolor:

Preview

update reset

SqlServerKudos

Welcome!

SQL SERVER – Stored Procedure Optimization Tips – Best Practices « Journey to SQL Authority with Pinal Dave

No comments yet, be the first one to post comment.

Open ID Login

Standard Login

Forgot Password?

Sign up