Is it possible to have two FILESTREAM columns in the same table?

Question

From the fact that I have not read anything, an explicit indication that you cannot have two FILESTREAM columns in the same table, but provided that you need the ROWGUIDCOL identifier for FILESTREAM to work, and you cannot have two of them, is this possible?

Is it possible to use the same ROWGUIDCOL, but with two different FILESTREAM groups?

Answer 1

Before you can use the FILESTREAM data type, you must meet several requirements for Windows and SQL Server. You should familiarize yourself with the white paper located here " http://msdn.microsoft.com/en-us/library/cc949109.aspx " and titled "FILESTREAM Storage in SQL Server 2008".

I quote a section of the document that answers your specific question: “A table can have several FILESTREAM columns, but data from all FILESTREAM columns in a table must be stored in the same FILESTREAM filegroup. If the FILESTREAM_ON clause is not specified, depending on which which FILESTREAM filegroup will be installed by default, this may not be the desired configuration and may lead to performance problems.