Make SQL Server stored procedure results visible with SET NOCOUNT ON
Often, SQL Server stored procedures use the “SET NOCOUNT ON” command to improve performance. This command prevents DONE_IN_PROC messages from being sent to the client. In certain situations involving multiple iterations in loops, disabling such messages may noticeably boost performance and reduce network traffic. Hence, most discussions about SET NOCOUNT ON focus on the performance…
Details