All about technology and cool stuff.
Use SET NOCOUNT ON at the beginning of your SQL batches, stored procedures and triggers in production environments, as this suppresses messages like '(1 row(s) affected)' after executing INSERT, UPDATE, DELETE and SELECT statements.
This inturn improves the performance of the stored procedures by reducing the network traffic.
Posted by
Charles Vaz
at
6:13 AM
Note: Thanks to all the above authors/publishers for the above public educational links/material. All the above links are copyright material by the respective authors. Individual Copyrights are not displayed here due to space restrictions. The links/material displayed here, is not for commercial use, but for personal reading only. Certain names/titles may have been written in abbreviation format just to enable easy viewing and is in no way designed to infringe any trademark. No responsibility is hereby undertaken with regard to the validity/[accuracy of the content] of the links/material. All the above links were found by online searches and were provided as public material by the respective sites. Thanks again, to all the above authors/publishers for the above public educational links/material.
No comments:
Post a Comment