One of the best feature of
FileStream is : The SQL Server buffer pool is not used; therefore, this memory is available for query processing.
I have encountered an issue that If I create a stored procedure for return file from my
FileStream table, Will The SQL Server buffer pool be used? Is it possible to take advantage of benefits of
T-SQL and SPs?