Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Pictures or Graphics within SQL database
- Thread starter SQL2000
- Start date
Yes, they can be stored as BLOBS. I would recommend only doing it this way if you have to. It can really affect performance.
Unless there is some reason why I can't I prefer just storing the path and letting the file system take care of the rest. It is faster. You do lose any SQL Server Security this way though and you are at the mercy of Windows security. I believe you can store images or files up to 2 gig in SQL Server.
Unless there is some reason why I can't I prefer just storing the path and letting the file system take care of the rest. It is faster. You do lose any SQL Server Security this way though and you are at the mercy of Windows security. I believe you can store images or files up to 2 gig in SQL Server.
- Status
Similar threads
- Question
