When a query executes in sql server, it automatically calculates the count of the data which it return. This is really an overhead for Sql server in case of returning large result set. To improve the performance of the query, we can use SET Nocount ON.
Look at the below example.
Example For SET NOCount ON