What are the advantages and disadvantages of turning NOCOUNT off in SQL Server queries?
From SQL BOL: SET NOCOUNT ON prevents the sending of DONE_IN_PROC messages to the client for each statement in a stored procedure. For stored procedures that contain several statements that do not return much actual data, setting SET NOCOUNT to ON can provide a significant performance boost, because network traffic is greatly reduced. See http://msdn.microsoft.com/en-us/library/ms189837.aspx for more details.
Related Questions
- How do Astra-Glaze-SW+ blocks compare to structural glazed facing tile (SGFT); are there any advantages or disadvantages?
- How do Astra-Glaze-SW+ blocks compare to structural glazed facing tile (SGFT); are there any advantages or disadvantages?
- What advantages/disadvantages are there to having redundancy at the broker, rather than node, level?
- What are the advantages and disadvantages of turning NOCOUNT off in SQL Server queries?
- What are the advantages and disadvantages of downloading music?
- What are the advantages and disadvantages of downloading music?
