Solved

Reducing Image File Size in SQL Server 2005

Posted on 2009-04-01
5
646 Views
Last Modified: 2012-05-06
I have a table for file attachments, and the majority of them are images.  They are stored in image field iin SQL server, with a corresponding "mimetype" varchar field indicating the file type (if that matters). There are a few hundred TIFF and BMP files, but the majority (15,000) of them are listed as PJPEG file types

I would like to run something to reduce the size of these images, I know many are 5-10MB and they don't need to be anywhere that big.  The backup filesizes are getting out of hand and it's all due to these pictures.

What are my options to reduce the size of these images or the table as a whole?
0
Comment
Question by:synapse88
5 Comments
 
LVL 21

Accepted Solution

by:
pinaldave earned 250 total points
ID: 24040269
Unfortunately answer to your question is that it is not possible using any solution of SQL.

You may have to programmatically reduce this in your application

Regards,
Pinal Dave
0
 
LVL 9

Assisted Solution

by:cdaly33
cdaly33 earned 250 total points
ID: 24040340
I can't think of a way to do it in sql but I use the techniques described in this post on a daily basis and it works great for me.  You could make a process that runs every so often to look for files over a certain size and run the thumbnail routine on them.
http://forums.asp.net/t/521072.aspx
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 24045453
It is not possible.
0
 

Author Comment

by:synapse88
ID: 24045796
Well is there some program (.net or otherwise) that will process the images to reduce the filesize?
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question