有一个很好的研究论文由微软研究所发布的到Blob或不到Blob ，他们查看各种变量和影响。

There was a nice research paper published by Microsoft Research called To Blob or not to Blob where they looked at all sorts of variables and impacts.

他们的结论：

• 大小最大为256 KB，blob在数据库中比在文件系统中更有效地


• 对于1MB或更大的文件系统，文件系统更有效

SQL Server 2008还添加了FILESTREAM属性，可以在文件系统中存储内容，事务控制，现实。强烈推荐你检查一下！

Since that paper was published, SQL Server 2008 has also added the FILESTREAM attribute which makes storing stuff in the file system, but under transactional control, a reality. Highly recommended you check that out!