title: SQL Server: table datatypes to smallest possible space to overcome limit of maximum allowable table row size of 8060 bytes?
body: <p>I am getting a similar error as <a href="https://stackoverflow.com/questions/20219607/sql-server-row-size-limit-and-table-design">here</a></p>
  
  <blockquote>
    <p>Creating or altering table 'MediaLibrary' failed because the minimum
    row size would be 14273, including 9 bytes of internal overhead. This
    exceeds the maximum allowable table row size of 8060 bytes.</p>
  </blockquote>
  
  <p>after importing a CSV with SQL Server Management Studio. Number columns are interpreted as strings so, instead of efficient (n)archer(x) datatype, the datatype may be nchar(1000) taking a lot of unnecessary space.</p>
  
  <p>How can I see the datatypes of the table imported to SQL Server and update them to take the smallest amount of space?</p>