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 FileStream with T-SQL and SPs?


  • Have you encountered the issue that it is using that memory? Your question isn't really clear. Sep 21, 2017 at 4:41


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.