Best Practices Best Practice No.4 May 16, 2013 Sarabpreet Singh Anand Use Set NOCOUNT ON for all Batches, Stored Procedures and Triggers to reduce Network traffic for SQL Server.