title: SQL SELECT statement with Image column slow
body: <p>I'm running a SELECT query in SSMS and it takes a very long time to finish. More than 30 minutes.</p>
  
  <p>There is a Image column in the SELECT clause, and as soon as I remove that, the query runs normal.  </p>
  
  <p>Now I can see other forums firtsly state that you should not use the Image datatype for several reasons, and I agree.  But this database have it (15 years old), and I cannot change it now.  Also, there is some fairly big images in that column (> 20MB).</p>
  
  <p>There are approx 8000 records to retrieve.</p>
  
  <p>Any pointers on how to increase the performance when the Image is in the SELECT clause?  Indexes, views, ...?</p>
  
  <p>Eg:</p>
  
  <pre><code>SELECT ID, Title, MyImageColumn
  FROM MyTable
  </code></pre>