title: SQL Server 2008 FILESTREAM performance
body: <p>I had some questions around the FILESTREAM capability of SQL Server 2008.</p>
  
  <ol>
  <li><p>What would the difference in performance be of returning a file streamed from SQL Server 2008 using the FILESTREAM capability vs. directly accessing the file from a shared directory? </p></li>
  <li><p>If 100 users requested 100 100Mb files (stored via FILESTREAM) within a 10 second window, would SQL Server 2008 performance slow to a crawl?</p></li>
  </ol>