tags:

views:

23

answers:

1
Q: 

What are the disadvanges and advantages of using NoCount in Reporting Services?

What are the advantages and disadvanges of using the Set NOCount on TSQL for Reporting Services.

A: 

Advantages:

  • You avoid unnecessary processing to return the row counts.

Disadvantages:

  • You drive yourself crazy trying to micro-optimize your report.
Jeremy Stein  2010-03-22 19:33:50
Short and straight to the point thank you
Kip Birgen  2010-03-23 10:14:48

related questions

is the text on Chart legend can be changed?
Reporting Services RangeBar Chart X-Axis labels time portion only of a datetime value
SSRS: Asp.NET ReportViewer parameters reset to default when clicking View Report
Installing Report Manager on a separate server with SSRS 2008
Passing Credentials to Sql Report Server 2008
Reporting Services Parameter Constraint
Storing and retrieving session variables in Reporting Services 2008
Upgrading Reporting Services RLD 2005 --> 2008
How to use Multiple result sets in Reporting Services
Using objects as a data source for a remote SQL Server Reporting Services report
Is there a way to have an SSRS 2008 chart show top X results and group/sum the rest as other?
Reporting services right item alignment
SSRS Multi value parameters - appropriate layer for implmentation of the filter
SQL 2008 Reporting Services Authentication.
SSRS 2008 and SSAS 2008 transport error
Reporting Services Excel rendering extensions ?
SQL2008: MSOLAP & SSRS Class not registered error with certain dimension.
SSRS can't conditionally filter "nil" values from XML Data Source?
SSRS Report Builder 2.0 - Use with SQL 2005
Can't add domain users to Reporting Services 2008
"Error: Thread was being aborted" when report subscription is executed in MSRS 2008
Installing RS2008 against SQL Server 2000
Did Visual Studio 2008 Support SQL Reporting services 2008.
How do I register a Web Reference for a SQL Server 2008 Reporting Service Report?
Deploy multiple instance of reporting services or connect to multiple versions of DLLs