title: How to store images in SQL Server
body: <p>I do know that there is a answer <a href="https://stackoverflow.com/questions/5613898/storing-images-in-sql-server">here</a></p>
  
  <p>But I want to know these:</p>
  
  <ol>
  <li><p>I know how to save them programmatically, but I don't know what data type to save them? Could I still use <code>image</code> datatype when I have converted my images as image to 256KB? Or should I save them into filestream data type?</p></li>
  <li><p>What kind of fragmentation is the document about? In my scenario, I have 2k+ employees and counting, so that means my application would get bigger over time, If I saved the images as image, and did not followed the rules as stated by the research paper, would my images lose their intact picture? (e.g a picture with blue background somehow changes its color maybe?)</p></li>
  <li><p>Should I save it in the exact table of my employee details table? Or should I save it in a different table?</p></li>
  <li><p>Sorry but I did not really understand the NTFS thing, is it the RAM of my computer? Or the RAM of my server? And I am using a file server as my database, should I still convert my images or should I go with using <code>image</code> data type without the conversion?</p></li>
  </ol>