Solved

Limit of saving file in sql table

Posted on 2013-02-03
7
144 Views
Last Modified: 2013-02-03
I dont want to use SQl Server's filestream. I want to save the files in a table in database using varbinary(max)....

How big the file can be?
0
Comment
Question by:Camillia
  • 3
  • 3
7 Comments
 
LVL 9

Expert Comment

by:Aeriden
ID: 38849041
0
 
LVL 9

Accepted Solution

by:
Aeriden earned 250 total points
ID: 38849043
Sorry, the link is for SQL 2012.  For SQL 2008, reference http://msdn.microsoft.com/en-us/library/ms188362%28v=sql.100%29.aspx

(still the same maximum size)
0
 
LVL 7

Author Comment

by:Camillia
ID: 38849060
If i want to think in terms of pages, how many pages is 2GB? or i cant compare it as such?
0
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 
LVL 9

Expert Comment

by:Aeriden
ID: 38849268
In the old days (circa SQL Server 4.x and 6.x) we used to think in terms of pages.  I haven't thought that way in a long time (haven't needed to).  Perhaps you could provide some insight as to why pages would be of concern to you (and perhaps relevant)?
0
 
LVL 7

Author Comment

by:Camillia
ID: 38849275
I want to explain to my manager what 2GB compares to # of PDF files.
0
 
LVL 75

Assisted Solution

by:Anthony Perkins
Anthony Perkins earned 250 total points
ID: 38849617
I want to explain to my manager what 2GB compares to # of PDF files.
Unfortunately, you cannot do that.  The best you can do is pick some random files and divide the sum of all the sizes by the total number of pages.  For example the PDF that I see are a little over 2Kb per page, but I am talking about a PDF with over half a million pages.

But I do need to add that if you have PDFs with anywhere close to 2 GB and you are attempting to save in database you have bigger problems.

Good luck with your approach and make sure to come back to this thread in say about a year or two and tell us how it worked out for you.
0
 
LVL 7

Author Comment

by:Camillia
ID: 38849669
Thanks. Not going to store 2GB of files. I was just looking at example. Going to put a limit on the size of the file we save.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

706 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now