<div>
Can you elaborate on:<br />
<br />

<blockquote>
There are some good reasons why this can work well and some reasons why it won't.
</blockquote>
</div>


Can you elaborate on:



> There are some good reasons why this can work well and some reasons why it won't.

<div>
It's probably to much of an in depth subject to go into here, when it is already documented elsewhere, as well as the link provided above see the Microsoft article below :<br />
<br />
<a href="http://research.microsoft.com/apps/pubs/default.aspx?id=64525" rel="ugc">To BLOB or Not to BLOB</a>
</div>


It's probably to much of an in depth subject to go into here, when it is already documented elsewhere, as well as the link provided above see the Microsoft article below :

To BLOB or Not to BLOB [http://research.microsoft.com/apps/pubs/default.aspx?id=64525]

<div>
<div class="content wysiwyg-content">
Sorry to sound naive, not a DBA or devloper, but I recently got copied into an architecture diagram for a new records management application, and noticed it had an MSSQL database, for records management type apps (similar concept to sharepoint), that are used to store office documents, i.e. docx, xlsx etc, surely those files dont reside in the database do they? I always viewed databases as storing only text only type data, not actual files. So if thats the case, what role would the database play (provide links to the files on a file share?)? ANy basic low tech management freindly explanation most welcome.
</div>
</div>


Sorry to sound naive, not a DBA or devloper, but I recently got copied into an architecture diagram for a new records management application, and noticed it had an MSSQL database, for records management type apps (similar concept to sharepoint), that are used to store office documents, i.e. docx, xlsx etc, surely those files dont reside in the database do they? I always viewed databases as storing only text only type data, not actual files. So if thats the case, what role would the database play (provide links to the files on a file share?)? ANy basic low tech management freindly explanation most welcome.

MSSQL behind records management application

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.