Sometimes even the simplest things can make a difference. One of
these simple items that should be part of every stored procedure is SET
NOCOUNT ON. This one line of code, put at the top of a stored procedure
turns off the messages that SQL Server sends back to the client after
each T-SQL statement is executed. This is performed for all SELECT,
INSERT, UPDATE, and DELETE statements. Having this information is handy
when you run a T-SQL statement in a query window, but when stored
procedures are run there is no need for this information to be passed
back to the client.
By removing this extra overhead from the network it can greatly improve overall performance for your database and application.
By removing this extra overhead from the network it can greatly improve overall performance for your database and application.
