I made an application that store Item pictures (jpeg) in SQL Server DB,

the use shot pictures with his camera (file size ~ 2 M), in my

aaplication I check if picture.Width > 800 or picture.Height > 600, I

resize the picture to 800x600.

-- if I export picture from DB, the file size is about 100k, if I open

the same picture in photoshop, the image size shows 1.37M.

01-- I want to know the space that takes this picture in my DB.

The reason I'm resizing the picture before storing it in my DB, is that

I imagine it take a huge space in my DB.

02-- How to resize a picture to keep it' s aspect ratio?