title: One table for all files or many tables with file column?
body: <p>Solution one would be having about 20 tables that could hold files in a separate column and second solution the option of having 20 tables and one extra table containing all files and have links/relationships between the file table and the other 20 tables. The files are small PDF files of about 0,5 MB. Seems safer with columns so no client could see other clients data by mistake. Columns would be varbinary MAX</p>