Stack Overflow
Stack Overflow

Questions tagged [filetable]

FileTable helps integrate SQL Server Databases with FileSystem storage by leveraging existing FILESTREAM capabilities.

The FileTable feature brings support for the Windows file namespace and compatibility with Windows applications to the file data stored in SQL Server. FileTable lets an application integrate its storage and data management components, and provides integrated SQL Server services - including full-text search and semantic search - over unstructured data and metadata.

In other words, you can store files and documents in special tables in SQL Server called FileTables, but access them from Windows applications as if they were stored in the file system, without making any changes to your client applications.

The FileTable feature builds on top of SQL Server FILESTREAM technology. Notably, FileTable allows non-transactional access to the files, something not possible with FILESTREAM.

130 questions
0
votes
0 answers

SQL FileTable GetFileNamespacePath

I am using Filetable in SQL 2016. let's take a look at some select commands below: 1. Select [stream_id] from 2. Select [stream_id], [name] from with (nolock) 3. Select [Stream_id], [name],…
Hessam Hosseini
  • 53
  • 1
  • 7
0
votes
0 answers

SQL Server semantic search: varchar(max) vs filetable

According to your experience, what's the best option for performing semantic searches for html, word and pdf files? Should the files be saved in a varchar(max) column or directly on disk (in a FileTable)? File sizes aren't restricted to a maximum…
Luis Abreu
  • 4,008
  • 9
  • 34
  • 63
0
votes
1 answer

SQL Server performance with FILESTREAM feature on

We have a large SQL Server instance, and we are planning to use FILETABLE in one of the new databases. For using FILETABLE, we need to enable FILESTREAM feature at the SQL Server instance level with FILESTREAM access level settings. We are worried…
Mani Live
  • 168
  • 1
  • 7
0
votes
0 answers

SQL Server - Set FileTable Directory to "C:\Example"

How do I set a FileTable_Directory to a custom path such as C:\Example? Can I change this directory on demand and will it reflect the changes upon update in the database? Here's my FileTable setup: -- Enable Filestream EXEC sp_configure…
Daniel Harris
  • 1,805
  • 10
  • 45
  • 63
0
votes
4 answers

SQL Server FileTable move directory with content T-SQL

i am currently looking at trying to move a directory in a FileTable from one location to another. I cannot seem to find any information on how to move a directory that has sub directories and files in it to a different location via T-SQL. i have…
lilpug
  • 141
  • 1
  • 6
0
votes
2 answers

How to access files stored in SQL Server's FileTable?

As I know SQL Server since version 2012 has a new feature, FileTable. It allows us to store files in the file system and to use them from T-SQL. I am trying to use this feature and I have no idea how to do it properly. Generally, I don't know how…
Pupkin
  • 1,211
  • 3
  • 13
  • 30
0
votes
0 answers

How to check if FileTable is enabled in SQL Server database

Before I store data into SQL Server FileTable, I need to know or verify that the FileTable exists in the database, then only I can add the records to FileTable. If FileTable is not enabled or added to Database then I want to store the data in the…
KtmKid
  • 11
  • 2
0
votes
0 answers

SQL FileTable Files in directory and HDD free space

We have 2 folder in filetable directory. "$FSLOG" and the second one have stored files (my question is about second folder). Every time I open file. They are like temp files. Even if I delete the filetable rows they are still there. For example I…
user2541236
  • 11
  • 1
  • 5
0
votes
0 answers

Blob storage for both SQL Server and Oracle

I have an application currently working on the SQL Server 2012 and Microsoft stack. I have a lot of images and documents which are required to be versioned and stored. Since the database was SQL Server, I was using Filetable & Filestream for…
Sharath Chandra
  • 654
  • 8
  • 26
0
votes
1 answer

Retrieving text from FileTable SQL Server

Is it possible to retrieve the actual text from a File Table in SQL Server 2014? I want to implement some hit-highlighting functionality, but in order to do so, I need to retrieve the actual text in the file I indexed, since the content is in a…
aluncob
  • 87
  • 2
  • 12
0
votes
0 answers

How to protect FileTable files from changing or removing by windows users

I've recently migrated my blob tables into FileTables, the problem that I'm facing is people can easily change or remove Files from the disk. For example I removed a file from the disk and this is what Sql Server tells me when I select a couple of…
Ali. B
  • 65
  • 9
0
votes
1 answer

Implementing FileTable

I've got a quick question which I hope I can get some help with. I need to create a database and then implement File Tables for the following text files: testFile1.txt testFile2.txt testFile3.txt Once this process is finished, I simply have to…
nica_cher
  • 11
  • 4
0
votes
1 answer

Need to figure out how much FileTable is using up in space

I need to figure out how many files have been inserted on a MS Sql Server FileTable along with their average size. The FileTable is already quite large, it' housing around 27GBs of data. This is the SQL i'm using, but it's extremely slow. It's been…
bastos.sergio
  • 6,684
  • 4
  • 26
  • 36
0
votes
1 answer

Is it possible to convert a SQL FileTable path_locator back to the GUID that was used to generate it

I'm creating a path in a SQL FileTable using the following code SET @path = '/' + CONVERT(VARCHAR(20), CONVERT(BIGINT, SUBSTRING(CONVERT(BINARY(16), @customerId), 1, 6))) + '.' + CONVERT(VARCHAR(20), CONVERT(BIGINT,…
Paul Marsden
  • 151
  • 11
0
votes
1 answer

Does SQL Server Express support FileTable

Does SQL Server Express support filetables? If not, what's the nearest approach to filetables in SQL Server Express?
Mahdi Tahsildari
  • 13,065
  • 14
  • 55
  • 94
1 2 3
…
8
9