I have an existing ASP.Net Core 2.0 project that uses Entity Framework Core and an SQL Server 2012 database. There is a requirement to add a form that allows users to upload documents when creatin...

I have an ASP.NET website. I want to upload a file to the website and save it into a FileTable in SqlServer 2012. Once uploaded, my website code has a Stream object which I would like to save usin...

I want to store images in a sql database. The size of the image is between 50kb to 1mb. I was reading about a FileStream and a FileTable but I don't know which to choose. Each row will have 2 image...

I'm building an app which needs to save files to filetable through the file share. I've already managed to get it working, but I'm curious about the solution required. In my case, I'm using a par...

After successfully creating a FileTable, I tried viewing the fileshare but my permissions are denied. In Management Studio, right-clicking on FileTable then "Explore FilteTable Directory" gives me ...

EDIT - To be clear I will put the goal sentence at the top. The test and my question is whether there is a way to get the same performance as a temp table without using a temp table. I feel t...

Previously, I requested how to create a directory within a FileTable without using File I/O APIs. I now want to create a subdirectory to the parent directory I just created. How do assign my parent...

Background/Problem I'm trying to do something along the lines of the following but can't find it documented: SQL Azure Database (not VM) Hook it up to some (blob) storage Utilize FileTables to s...

I am confused about Unix system file tables. When two or more processes open a file for reading, does the system file table create separate entries for each process or a single entry? If a single...

I'm looking at using File Tables instead of simply storing the file as binary data in the database, or storing a column in the database that contains a URL to a file share. Our apps use Entity Fram...

I am trying to create directories in a SQL Server FileTable via a stored procedure where I call the following code: INSERT INTO tblMyFiles (name, is_directory, is_archive) VALUES ('foldername', 1...

Recently our team was looking at FILESTREAM to expand the capabilities of our proprietary application. The main purpose of this app is managing the various PDFS, Images and documents to all of the ...

Is there a way to create directories in a FileTable without using File I/O APIs? Is it just as simple as creating a SQL INSERT statement? This is my first experience with SQL Server 2012 and I'm ...