Set nocount on Best Practices

While writing any stored procedure make use of set nocount on.

Select, Insert, Update and Delete you must have already seen the “nn row(s) affected” message making part of the result of your query

But this message may generate a great impact in the performance of your Stored Procedures

The Set NoCount option disables the sending of these messages. It will increase the performance while executing SPs over the network