I have a VB program where I am accessing SQL server. I would like to also program the ability to connect a document and save it in the SQL database. Is it possible to store pdf, jpegs, xls, and files of any sort within SQL? If so, what is the datatype? Does performance slow down over time as these types of files are stored since they take up more space? Can I archive these files every couple years in the database to free up the space?
Any suggestions on this topic would prove to be helpful.