ASYNC_NETWORK_IO or NETWORK_IO

What is ASYNC_NETWORK_IO  or  NETWORK_IO ? When a query is fired, SQL Server produces the the results ,place it in output buffer and send it to client/Application. Client/Application then fetch the result from the Output buffer, process data  and send acknowledgement to SQL Server. If client/Application takes long time to send acknowledgement then SQL Server…

0

Queries with table variables are slow in SQL2005 compared with SQL2000 (Table Variables (VS) Temp Tables)

Table Variables (VS) Temp Tables SQLServer2005 caches temp tables and temp variables only under some conditions. Scenarios where temp table/variable are not cached (see below) may cause performance degradation as compared to SQLServer2000. Following are scenarios where temp table/variable are not cached:1. select into #t2. alter table #t3. create index on #t4. Global temp tables…

2