Sql Queries, Sql Tips, Sql Server, Programming Tips, Sql.
operations, so when you have complex queries with a lot of joins, it can affect performance. With SET NOCOUNT ON, SQL will not count the affected rows and improve performance. In the following example, we are preventing the message about the number of rows affected from displaying. USE