title: Store big arrays (Lists) of data in XML format into SQL server 2016
body: <p>I need to save the result from several measurements generated in C#.<br>
  The results are big Lists of data of different types: </p>
  
  <pre><code>List&lt;double, double&gt; [20000 records]
  List&lt;string, double, double&gt; [20000 records]
  List&lt;int, double, double&gt; [20000 records]
  </code></pre>
  
  <p>My first thought was to store these lists in XML format into a table (xml field).
  So, for each List I generate a XML file and insert it into the table.</p>
  
  <pre><code>&lt;MeasurementList&gt;
    &lt;item&gt;
      &lt;left_measurement&gt;0.1264&lt;/left_measurement&gt;
      &lt;right_measurement&gt;6.500&lt;/right_measurement&gt;
    &lt;/item&gt;
    &lt;item&gt;
      &lt;left_measurement&gt;0.2314&lt;/left_measurement&gt;
      &lt;right_measurement&gt;6.968&lt;/right_measurement&gt;
    &lt;/item&gt;
    &lt;item&gt;
      &lt;left_measurement&gt;0.2365&lt;/left_measurement&gt;
      &lt;right_measurement&gt;7.598&lt;/right_measurement&gt;
    &lt;/item&gt;
    ...
  &lt;/MeasurementList&gt; 
  </code></pre>
  
  <p>This will occur 3000 times a day, so I need 9000 records each day.</p>
  
  <p>I know that the disk space is an issue, but my main concern is:<br>
  Is this is the best aproach or there are any other solutions</p>