This approach is effective to maintain transactional consistency and reduces the file management complexity, but when the client application reads data from the SQL table, it uses SQL memory which leads to poor performance. Unstructured files can be stored in the VARBINARY or IMAGE column of a SQL Server table. Before FILESTREAM was introduced, the following approaches were used to store the data in SQL server: The purpose was to store and manage unstructured files more effectively. FILESTREAM has been introduced by Microsoft in 2008.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |