Performance Surprises and Assumptions : SET NOCOUNT ON
I revisit the impact that eliminating DONE_IN_PROC messages using SET NOCOUNT ON may or may not have on query performance.
I revisit the impact that eliminating DONE_IN_PROC messages using SET NOCOUNT ON may or may not have on query performance.
Tip : The SQL Server Numbers Table, Explained – Part 2