When a client application requests information from SQL Server using the default settings in ADO, OLE DB, ODBC, or DB-Library, SQL Server must follow this process:
The client application sends a request to SQL Server in a network package. This request can be any Transact-SQL statement or a batch containing multiple statements.
SQL Server interprets the request and creates a query plan to solve the request. The query plan is compiled and executed.
SQL Server packages the results in the minimum number of network packets and sends them to the user.
The clients start receiving network packets, and these packets are waiting in the network buffer for the application to request them.
The client application receives the information contained ...