Reduce SQL Filestream limit

  • lidds


    Points: 12

    I want to save images into an sql database, and in my situation the best way to do this is using filestream. The problem is that only images over 2MB are saved to filestream. However my images are smaller than 2MB and I may have around 400000 ages being saved which obviously makes the database large. My question is if there is a way to lower the MB size that is saved the filestream?

  • Erland Sommarskog


    Points: 23791

    Huh? There is no such limit. If you are only able to save images > 2MB ins size, you are doing something wrong.

    How are you saving the images? Plain INSERT? OpenSqlFileStream? Are you using a FileTable?

    What is the typical size of your images?

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP,[/font]

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply