Another SQL Server FILESTREAM Best Practice guide

Recently I was asked to advise a customer on a FILESTREAM implementation he was devising, and part of that ended up becoming this blog post that I hope can be of some help for you.

When to use FILESTREAM?

In SQL Server, BLOBs can be standard varbinary(max) data that stores the data in tables, or FILESTREAM varbinary(max) objects that store the data in the file system. The size and use of the data determines whether you should use database storage or file system storage. So, in a nutshell, these are the typical scenarios where this feature is best suited:

Read more: Greg's Cool [Insert Clever Name] of the Day
Read more: Blog do Ezequiel - Best Practices on FILESTREAM implementations

Posted via email from Jasper-net