title: Issue with varbinary(max) datatype in Sql Server
body: <p>I have created a table having two columns with datatype <code>varbinary(max)</code>. I am saving pdf files in binary format in these columns. There is no issue while inserting the pdf files in these columns. But when I am selecting even a single record with only one column of type <code>varbinary</code> in <code>select</code> query it takes around one minute to fetch the record. The size of pdf file inserted is of 1MB. Here is the sql query to fetch single record:</p>
  
  <pre><code>select binarypdffile from gm_packet where jobpacketid=1
  </code></pre>
  
  <p>Kindly suggest if there is a way to improve the performance with <code>varbinary</code> datatype.</p>