SQLServerCentral / Discuss Content Posted by Unknown Unknown / Article Discussions / Article Discussions by Author

Filetable User or Document ID?

blarsen06 — Wed, 09 May 2012 17:03:51 GMT

I've looked into the new Filetable feature a bit, but I can't see any [b]way to identify the upload user[/b]. I'm also not aware of a way to [b]get back the document ID immediately after upload[/b]. Does anyone else know of a way to achieve these two things? As a developer, (and accidental DBA) I'd like to begin using this feature, but if you can't tie these documents to an existing record, or identify the user who owns the document... I can't see a good use for it. Also, [b]do these documents dump into the same 1 folder forever[/b], or do they get organized in some way eventually? Anyone who's worked with thousands of files in 1 directory knows that it performs quite poorly while trying to search / scroll / sort / view etc in that folder.

Synonyms

Site Owners — Tue, 29 Jan 2008 23:33:17 GMT

Comments posted to this topic are about the item [B]Synonyms[/B]

Renewed

Site Owners — Fri, 16 Mar 2012 23:59:28 GMT

Comments posted to this topic are about the item [B]Renewed[/B]

The top 5 reasons to speak at SQL Rally

Site Owners — Fri, 16 Mar 2012 20:42:18 GMT

Comments posted to this topic are about the item [B]The top 5 reasons to speak at SQL Rally[/B]

SQL Server 2012 FileTable – Part 1

Site Owners — Fri, 06 Jan 2012 00:05:21 GMT

Comments posted to this topic are about the item [B]SQL Server 2012 FileTable – Part 1[/B]

SQL Server 2012 FileTable – Part 2

Site Owners — Wed, 18 Jan 2012 00:09:00 GMT

Comments posted to this topic are about the item [B]SQL Server 2012 FileTable – Part 2[/B]

S3OLV update and Reminder

Site Owners — Mon, 27 Feb 2012 01:45:21 GMT

Comments posted to this topic are about the item [B]S3OLV update and Reminder[/B]

New on SQLMag Tool Time Blog – Update to FineBuild

Site Owners — Sun, 26 Feb 2012 23:43:36 GMT

Comments posted to this topic are about the item [B]New on SQLMag Tool Time Blog – Update to FineBuild[/B]

SQL Cachestore flush

Site Owners — Sun, 26 Feb 2012 20:30:56 GMT

Comments posted to this topic are about the item [B]SQL Cachestore flush [/B]

Happy New Year

Site Owners — Sun, 26 Feb 2012 16:57:19 GMT

Comments posted to this topic are about the item [B]Happy New Year[/B]

PASS Summit Eval – Extended Events

Site Owners — Thu, 16 Feb 2012 21:18:22 GMT

Comments posted to this topic are about the item [B]PASS Summit Eval – Extended Events[/B]

SQL Saturday 99 – SSWUG Interview

Site Owners — Fri, 17 Feb 2012 09:39:59 GMT

Comments posted to this topic are about the item [B]SQL Saturday 99 – SSWUG Interview[/B]

SQL Server - Local temporary table

Site Owners — Fri, 17 Feb 2012 03:26:07 GMT

Comments posted to this topic are about the item [B]SQL Server - Local temporary table[/B]

Master Data Services Error: Resolving from a long-running stucked Staging Batch with Status “Queued to Clear” or “Not Running”

Site Owners — Thu, 16 Feb 2012 17:21:17 GMT

Comments posted to this topic are about the item [B]Master Data Services Error: Resolving from a long-running stucked Staging Batch with Status “Queued to Clear” or “Not Running”[/B]

The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered.

Site Owners — Thu, 16 Feb 2012 14:27:19 GMT

Comments posted to this topic are about the item [B]The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered.[/B]

PASS Chapter Tools–My Wish List

Site Owners — Mon, 13 Feb 2012 11:54:37 GMT

Comments posted to this topic are about the item [B]PASS Chapter Tools–My Wish List[/B]

Sharing Profiles

Site Owners — Mon, 13 Feb 2012 11:54:24 GMT

Comments posted to this topic are about the item [B]Sharing Profiles[/B]

See You at SQL Saturday!

Site Owners — Mon, 13 Feb 2012 11:54:07 GMT

Comments posted to this topic are about the item [B]See You at SQL Saturday![/B]

Blogsy and my iPad

Site Owners — Mon, 13 Feb 2012 11:53:53 GMT

Comments posted to this topic are about the item [B]Blogsy and my iPad[/B]

Using Powershell to Deploy Performance Monitor

Site Owners — Mon, 13 Feb 2012 11:53:39 GMT

Comments posted to this topic are about the item [B]Using Powershell to Deploy Performance Monitor[/B]

Battery Life–The Hidden Cost of Keeping a Laptop

Site Owners — Mon, 13 Feb 2012 11:53:20 GMT

Comments posted to this topic are about the item [B]Battery Life–The Hidden Cost of Keeping a Laptop[/B]

SQL Server 2012 (“Denali”): Contained Databases

Site Owners — Mon, 13 Feb 2012 11:52:58 GMT

Comments posted to this topic are about the item [B]SQL Server 2012 (“Denali”): Contained Databases[/B]

Sarasota IT Pro Camp

Site Owners — Mon, 13 Feb 2012 11:52:49 GMT

Comments posted to this topic are about the item [B]Sarasota IT Pro Camp[/B]

What I Will Do For You in 2012

Site Owners — Mon, 13 Feb 2012 04:43:33 GMT

Comments posted to this topic are about the item [B]What I Will Do For You in 2012[/B]

Capacity planning for new hardware

Site Owners — Mon, 13 Feb 2012 04:36:17 GMT

Comments posted to this topic are about the item [B]Capacity planning for new hardware[/B]

Re-blog – December 23 – December 29

Site Owners — Mon, 13 Feb 2012 04:32:24 GMT

Comments posted to this topic are about the item [B]Re-blog – December 23 – December 29[/B]

PASS Election Results

Site Owners — Mon, 13 Feb 2012 04:31:46 GMT

Comments posted to this topic are about the item [B]PASS Election Results[/B]

January #Meme15 Assignment

Site Owners — Mon, 13 Feb 2012 04:08:22 GMT

Comments posted to this topic are about the item [B]January #Meme15 Assignment[/B]

2011 PASS Board Election Results

Site Owners — Mon, 13 Feb 2012 03:33:53 GMT

Comments posted to this topic are about the item [B]2011 PASS Board Election Results[/B]

Database uplevel Restores

Site Owners — Mon, 13 Feb 2012 03:31:29 GMT

Comments posted to this topic are about the item [B]Database uplevel Restores[/B]

Surrogate Keys

Site Owners — Mon, 13 Feb 2012 03:13:33 GMT

Comments posted to this topic are about the item [B]Surrogate Keys[/B]

#meme15 – Why Do You Blog?

Site Owners — Mon, 13 Feb 2012 03:12:22 GMT

Comments posted to this topic are about the item [B]#meme15 – Why Do You Blog?[/B]

Revised: Difference between collation SQL_Latin1_General_CP1_CI_AS and Latin1_General_CI_AS

Site Owners — Mon, 13 Feb 2012 03:04:49 GMT

Comments posted to this topic are about the item [B]Revised: Difference between collation SQL_Latin1_General_CP1_CI_AS and Latin1_General_CI_AS[/B]

SQL Server-Table Variable

Site Owners — Mon, 13 Feb 2012 02:54:10 GMT

Comments posted to this topic are about the item [B]SQL Server-Table Variable[/B]

SQL Index Fragmentation and sys.dm_db_index_physical_stats

Site Owners — Mon, 13 Feb 2012 02:33:20 GMT

Comments posted to this topic are about the item [B]SQL Index Fragmentation and sys.dm_db_index_physical_stats [/B]

Database Data and Log Size Info

Site Owners — Mon, 13 Feb 2012 02:28:21 GMT

Comments posted to this topic are about the item [B]Database Data and Log Size Info[/B]

Webcast: Putting a Better SQL Server in Production

Site Owners — Mon, 13 Feb 2012 02:19:53 GMT

Comments posted to this topic are about the item [B]Webcast: Putting a Better SQL Server in Production[/B]

My Top 5 for 2011

Site Owners — Mon, 13 Feb 2012 02:18:12 GMT

Comments posted to this topic are about the item [B]My Top 5 for 2011[/B]

Retrieving position() value of node by using XQuery alone

Site Owners — Mon, 13 Feb 2012 02:17:58 GMT

Comments posted to this topic are about the item [B]Retrieving position() value of node by using XQuery alone[/B]

Meme Monday January 2012

Site Owners — Mon, 13 Feb 2012 02:17:27 GMT

Comments posted to this topic are about the item [B]Meme Monday January 2012[/B]