Camillia
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?
How big the file can be?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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)?
ASKER
I want to explain to my manager what 2GB compares to # of PDF files.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
Source: http://msdn.microsoft.com/en-us/library/ms188362.aspx