title: Sql Msg 1701, Level 16, State 1 while making a very wide table for testing purposes
body: <p>I am making a huge table simulating a very rough scenario in SQL (a huge table with 1024 atts, of course a lot of rows if you wonder), the data type for each attribute are floats.</p>
  
  <p>To do so I am using another table which has 300 attributes and I am doing something like</p>
  
  <pre><code>SELECT [x1]
        ,[x2]
        ,[x3]
        ,[x4]
        ,[x5]
        ,[x6]
        ,[x7]
        ,[x8]
        ,[x9]
        ,[x10]
        ,[x11]
        ,[x12]
        ,[x13]
        ,[x14]
        ,[x300]
        ,x301= x1 
        ,x302= x2 
         ...
        ,x600= x300
        ,x601= x1   
        ,x602= x2 
         ...
        ,x900= x300
        ,x901= x1   
        ,x902= x2 
        ...      
        ,x1000= x100
        ,x1001= x101   
        ,x1002= x102   
        ,x1003= x103   
        ,x1004= x104  
        ...
        ,x1024= x124
  INTO test_1024
  FROM my_300;
  </code></pre>
  
  <p>However an error is present:</p>
  
  <pre><code>Msg 1701, Level 16, State 1, Line 2 
  Creating or altering table 'test_1024' failed because the minimum row size 
  would be 8326, including 134 bytes of internal overhead. This exceeds the 
  maximum allowable table row size of 8060 bytes.
  </code></pre>
  
  <p>How to overcome this issue? (I know SQL can handle 1024 columns...)</p>