Storage of unstructured data has always posed many challenges in terms of maintaining consistency between structured and unstructured data, managing backup/restore procedure, performance issues, scalability. This series shall discuss the use of Filestream to store unstructured data and how to create a sequence in an SQL server.
In earlier versions of SQL Server, storage of unstructured data posed many challenges in terms of maintaining consistency between structured and unstructured data, managing backup/restore procedure, performance issues, scalability, etc. This post explains to you how to use SQL Server FILESTREAM to store unstructured data. Here you can also read the positive and negative sides of FILESTREAM. Here are some other SQL queries to help you use it.
This post explains how Sequence works in SQL Server that has started to be used since the 2012 version. First, SEQUENCE is a separate object and is not bound to a specific table and one SEQUENCE object can be used on multiple tables in parallel. Second, SEQUENCE can be altered. Then the SEQUENCE object can define the rank etc The SEQUENCE object is most commonly used to obtain the value for a surrogate key in tables, most commonly used in the same way as IDENTITY is used.