Excel blobs and BCP extract commands

[robert_volk]

If this is a new thing, and if you expect to have more than 10 thousand documents, or 10 GB of data, PLEASE DO NOT store them in blob columns in SQL Server. It will quickly become an administrative hassle.

My additional comments here:

Select correct table based on year

The most flexible way is to create a partitioned view: CREATE View AllDocs AS SELECT * FROM [2020Docs] UNION ALL SELECT * FROM [2021Docs] UNION ALL SELECT * FROM [2022Docs] UNION ALL SELECT * FROM [2023Docs] UNION ALL SELECT * FROM [2024Docs] GO To get optimal performance, you'd need to add a constraint on the date column in each table, like so: ALTER TABLE [2020Docs] ADD CONSTRAINT CHK_2020Docs CHECK (DateCol BETWEEN '2020-01-01' AND '2020-12-31 23:59:59.997') You add a similar constraint …

The comment I made about PDFs not compressing also applies to XLSX files, they are already compressed, so your database backups will not get any benefit from backup compression.