SQL Server, better performance with the NOCOUNT option
Hi Guys, As you know in our blog, the final goal is always performance. So today is the time to talk about another best practice. Are you Ready? yes? go! p.s. By the way, if you want to know when my posts come out follow me also on linkedin here SET NOCOUNT ON What is the option NOCOUNT? The NOCOUNT is an option, its value can be ON or OFF and determines whether the DONE_IN_PROC messages are sent to the client of not. The DONE_IN_PROC message indicates the completion status of an SQL statement within a stored procedure (and therefore also a trigger). Inside a SP a message is sent for ech executed statement. By default, the NOCOUNT option is set to OFF but you can set it to ON with the command SET NOCOUNT ON In this case, SQL Server will not send the DONE_IN_PROC messages . DONE_IN_PROC messages are sent to the client via the TDS protocol. Tabular (o token) data Stream (or TDS) is the protocol implemented by drivers that allows an applicatio...