Storing of Images and other unstructured data is quite common activity and most developers has done this task in their own way like by saving Data File in some file server and storing the address in database. Some might have saved the files in DB only by storing the Unstructured File in ByTe[] array and saving in BLOB or VARBINARY data type.

SQL Server 2008 R2 has introduced new way of storing unstructured Data files in BLOB or VARBINARY(MAX) and getting it managed by NT based file system. This new method overcomes all the overheads caused by saving Unstructured data in DB. Reading and Writing data from FileStream is same as using VarBinary or Blob type columns.

Leave a Reply

Your email address will not be published. Required fields are marked *