SET NOCOUNT ON and performance
Does SET NOCOUNT ON speed up a procedure? Bytes, packets and time measured on SQL Server 2025 over a simulated slow network, and against row-by-row code.
SQL Server questions and answers
Short, measured answers to precise SQL Server questions: what the engine does, checked on a real instance.
Each page answers one precise question, asked during a training course, at a client site or by a reader. The answer is checked on a real instance, with the script that lets you run it again.