sarabpreet.com
Best Practice No.4
Use Set NOCOUNT ON for all Batches, Stored Procedures and Triggers to reduce Network traffic for SQL Server.