Using "SET NOCOUNT ON"

Unless there is a specific reason to require the count, make "SET NOCOUNT ON" the first command in each stored procedure.