title: SQL Server 2012 consumes too much network traffic to fetch all data
body: <p>Today I did a test using AnyDAC (firedac) to fetch all data available in my remote SQL Server 2012.</p>
  
  <p>My table that I fetch data from has these simple columns:</p>
  
  <pre><code>1. date - (size 3 byte)
  2. time - (max 5 byte)
  3. int - (4 byte)
  4. bit - (1 byte)
  5. int - (4 byte)
  6. float - (4 byte)
  7. float - (4 byte)
  8. int - (4 byte)
  9. int - (4 byte)
  </code></pre>
  
  <p>Total row size should be max 33 bytes.</p>
  
  <p>Well, after fetching all rows available in my table (more than 2.14 million rows), I checked the received tcp traffic by FireDAC and observed that it is around 280MB which means each row needs around 130 byte while my expected value something close to 33 bytes.</p>
  
  <p>Another measurement that I did by using a stored procedure defined on server side which have an insert sql to the same table above and I called the stored procedure using Array DML feature of AnyDAC. Array size was 300K and totally I have added 18.8 million records using it. Traffic used for it realized as 2.85 GB. (so 150 bytes per row)</p>
  
  <p>Is there any configuration on FireDAC or SQL Server side to reduce traffic? Obviously, there is something wrong here. Any suggestions?</p>
  
  <p>Thanks.</p>
  
  <p>Info output:</p>
  
  <pre><code>================================
  Connection definition parameters
  ================================
  User_Name=*****
  Password=*******
  SERVER=sql.***.gen
  ApplicationName=Bist
  Workstation=NB
  DATABASE=BIST
  MARS=yes
  DriverID=MSSQL
  ================================
  FireDAC info
  ================================
  Tool = D18 Architect
  FireDAC = 8.0.1 (Build 3279)
  Platform = Windows 32 bit
  Defines = AnyDAC_Unicode;AnyDAC_DBX;AnyDAC_NOLOCALE_META;
    AnyDAC_MONITOR
  ================================
  Client info
  ================================
  Loading driver MSSQL ...
    Loading odbc32.dll driver manager
    Creating ODBC environment handle
    Searching for ODBC driver ...
      Checking for ODBC driver [SQL SERVER NATIVE CLIENT 11.0] ...
        Found [SQL Server Native Client 11.0]
  Driver Manager version = 03.80.7601.0000
  ================================
  Session info
  ================================
  Current catalog = 
  Current schema = dbo
  Driver name = sqlncli11.dll
  Driver version = 11.00.2100
  Driver conformance = 3
  DBMS name = Microsoft SQL Server
  DBMS version = 11.00.2100
  </code></pre>