SQLServerCentral.com / SQL Server 2008 - General / SQL Server 2008 / Estimate storage for Images / Latest PostsInstantForum.NET v2.9.0SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 03 Mar 2015 14:19:14 GMT20RE: Estimate storage for Imageshttp://www.sqlservercentral.com/Forums/Topic1440424-391-1.aspxThank you Ben!This is very helpful indeed.Best regards,SteveWed, 10 Apr 2013 05:14:37 GMTSteveBellRE: Estimate storage for Imageshttp://www.sqlservercentral.com/Forums/Topic1440424-391-1.aspxHello,Making the following assumptions, the fotos are portrets of people, so in general they are vertical. A very reasonable size for a picture would be a height of 800 pixels. For 3:2 this would give a pixelsize of 800 x 530 pixels.A good quality picture would be about 100 kb to about 500 kb. And for very complex pictures the size would go up to 700 kb (for pictures with a lot of structures).If you do not have control over the size of the pictures, 16 Mp pictures can take up far more space, this can take around 10 Mb voor a single picture.So it does depend, but 500 kb for a picture gives enough quality for most pictures used on a screen.Ben BrugmanTue, 09 Apr 2013 12:50:51 GMTben.brugmanRE: Estimate storage for Imageshttp://www.sqlservercentral.com/Forums/Topic1440424-391-1.aspxThanks Michael,And that's precisely my dilemma.Some Googling suggests that identification photos run between about 2 MB and 10 MB, and U.S. Passport photos are limited to 240 KB.I think for the purpose of the exercise I'm involved with, I'll assume a max size of 4 MB.Thanks again,SteveTue, 09 Apr 2013 09:55:13 GMTSteveBellRE: Estimate storage for Imageshttp://www.sqlservercentral.com/Forums/Topic1440424-391-1.aspxImages can vary greatly is size, so it depends on the type of images you are storing.If you don't know the image sizes, then any estimate is just a wild guess.Tue, 09 Apr 2013 09:51:41 GMTMichael Valentine JonesEstimate storage for Imageshttp://www.sqlservercentral.com/Forums/Topic1440424-391-1.aspxHi,I'm hoping that some of you have worked before with databases where Images are stored?I'm referring to the situation where we would store a photo of a person so that, when an end user opened up a record for the person, they would see the photo along with the information.Can anyone give me an estimate on what a good size would be to allow for these images?It's for an estimate of storage and growth requirements for a new database (so I don't have any available images to use as a baseline).I appreciate any thoughts that you can provide,SteveTue, 09 Apr 2013 09:27:12 GMTSteveBell