Community Content Add
Annotations FAQ
Dirty reads are possible with FILESTREAM

In the isolation semantics section of this article, there is this statement: "Dirty read is not supported."

However, it is possible for a transaction to modify FILESTREAM data, and before the change is committed the updated data can be read by another transaction of that other transaction has its isolation level set to READ UNCOMMITTED.