RE: How to store Excel files In SQL Table

SSC Guru

Points: 1003863

December 7, 2017 at 8:34 am

#1971182

fregatepallada - Thursday, December 7, 2017 1:17 AM
Complete LUNACY.
I highly recommend you to read this first https://www.microsoft.com/en-us/research/wp-content/uploads/2006/04/tr-2006-45.pdf
Are you aware of FILESTREAM capabilities (since SQL Server 2008).This IMHO would be much better approach than store BLOBs in table.

Heh... "Complete LUNACY". And, yet, the authors of that good document (and it IS well written by those with a high pedigree) say the following in the conclusion of their document.

We did not investigate the behavior of NTFS or SQL Server when multiple writes to multiple objects are interleaved. This may happen if objects are slowly appended to over long periods of time or in multithreaded systems that simultaneously create many objects.

Neither have the authors provided the code that they've actually done their testing with so that one could verify their methods.

Also, and to ask the question, have you actually done a performance comparison where you've methodically applied the scientific method and documented your findings or are you sharing the same anecdotal feelings that the authors of the document are trying to dispel?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)