SentryOne Team Blog (blogs.sentryone.com)

Tag : NOCOUNT

Performance Surprises and Assumptions : SET NOCOUNT ON

Aaron Bertrand (@AaronBertrand) revisits the impact that eliminating DONE_IN_PROC messages using SET NOCOUNT ON may or may not have on query performance.