7
Shouts
spam Shout it Mute it

SQL SERVER – Stored Procedure Optimization Tips – Best Practices « Journey to SQL Authority with Pinal Dave
published 1217 days, 15 hours, 25 minutes ago posted by pinaldavepinaldave 1217 days, 20 hours, 58 minutes ago
Thursday, February 18, 2010 2:05:33 PM GMT Thursday, February 18, 2010 8:32:20 AM GMT

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: Data | clicked: 1 | | source: blog.sqlauthority.com | show counter code
tags: SQL, SQLServer, Database, pinaldave, SQLAuthority