1

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?

Thanks

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

0

Reset to default

Your Answer

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