Was wondering whether anyone had any recommendations, or references to articles with recommendations, regarding best practices for tables with VARBINARY(MAX) data.
My particular scenario is that I have a table which is storing photographs of receipts, in a VARBINARY(MAX) column. After a year's worth of data, the size of that table has reached a pretty significant level, and I'd imagine it will only continue to grow.
As is obvious, if I run a SELECT * on the table, the result set takes quite a while to return. This isn't an issue, as all of my queries on that table are designed to return specific columns, and I'm only ever referencing the VARBINARY(MAX) column when specifically looking for a single record to return the receipt image from, and since it's a PRIMARY KEY lookup, the query runs very quickly.
Are there any issues that I should be aware of as this dataset grows? Any suggestions / advice on things I should be doing? I was considering having some sort of partitioned table, with every year having it's own partition, but I'm not convinced that it's even worth bothering, since thus-far I haven't encountered any actual problems.