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. – Randolph West Sep 21 '17 at 4:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.