title: SQL Server semantic search: varchar(max) vs filetable
body: <p>According to your experience, what's the best option for performing semantic searches for html, word and pdf files? Should the files be saved in a <code>varchar(max)</code> column or directly on disk (in a <code>FileTable</code>)? </p>
  
  <p>File sizes aren't restricted to a maximum predefined size, but most of them are expected to have more than 1 or 2 MB. We think that we'll be having several thousands docs a month (we might have more than 200k files uploaded a year) and we are interested in getting results from those 3 types of files. </p>
  
  <p>What are your recommendations?</p>
  
  <p>Thanks guys!</p>
  
  <p>Luis</p>