SQL Server: NOCOUNT

I always saw the SET NOCOUNT ON/OFF instruction in SQL Server stored procedures and triggers, but never knew exactly what it did. This quote from MSDN explains it perfectly:

Stops the message that shows the count of the number of rows affected by a Transact-SQL statement or stored procedure from being returned as part of the result set.

So, apparently it diminishes some network traffic by not showing the message of number of rows affected.

Full Article here.