title: Which data-type for storing images and documents in SQL Server 2005
body: <p>I must extend an existing .net-Application to store images and documents (mostly pdf's) in a SQL Server 2005 database. </p>
  
  <p>Which SQL Server datatype is used best for saving these files and is it meaningfull to create a separate table that holds the fields, or is it no problem to put these fields directly in the "normal" business tables, as long as the select statements do not select them (or SELECT *).</p>