{{theTime}}

Search This Blog

Total Pageviews

How to reduce amount of network data for SQL server stored procedure?


SET NOCOUNT ON

Every time a SQL Statement is executed it returns the number of rows that were affected.  By using
"SET NOCOUNT ON" within your stored procedure you can reduce some traffic.  You can still use
@@ROWCOUNT variable to get number of rows.

No comments:

java.lang.NoSuchFieldError: Class com.sun.tools.javac.tree.JCTree$JCImport

SpringBoot Error: java.lang.NoSuchFieldError: Class com.sun.tools.javac.tree.JCTree$JCImport does not have member field 'com.sun.tools.j...