Link to home
Start Free TrialLog in
Avatar of Camillia
CamilliaFlag for United States of America

asked on

Limit of saving file in sql table

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?
Avatar of Aeriden
Aeriden
Flag of United States of America image

ASKER CERTIFIED SOLUTION
Avatar of Aeriden
Aeriden
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Camillia

ASKER

If i want to think in terms of pages, how many pages is 2GB? or i cant compare it as such?
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)?
I want to explain to my manager what 2GB compares to # of PDF files.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.