In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Reducing Image File Size in SQL Server 2005
Posted on 2009-04-01
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?
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?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
5 Comments
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
You may have to programmatically reduce this in your application
Regards,
Pinal Dave
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
http://forums.asp.net/t/521072.aspx
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
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.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have.
In this…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month5 days, 19 hours left to enroll
627 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.