title: Max real space in a varbinary(max) in SQL Server
body: <p>I am saving files (any type ) in a SQL table, using a <code>varbinary(max)</code>, I find out that the max usage of this datatype is 8000, but what does the 8000 mean?</p>
  
  <p>The online documentation says that is 8000 bytes.  Does that mean that the maximum size of the file to be save there is 8000/1024 = 7.8125 KB?</p>
  
  <p>I start testing and the maximum file that I can store is 29.9 MB.  If I choose a larger file a get a SQLException.</p>
  
  <blockquote>
    <p>String or binary data would be truncated. The statement has been
    terminated.</p>
  </blockquote>