October 5, 2015 at 10:25 pm
Comments posted to this topic are about the item Filetable Trivia
October 6, 2015 at 12:13 am
This was removed by the editor as SPAM
October 6, 2015 at 12:18 am
Andy, very good question. However I would question the answer as regards the number of sub directories as the MSDN article quotes that restriction as Nesting Level restriction, not a restriction on subdirectories per sa:
"You cannot store more than 15 levels of subdirectories in the FileTable directory. When you store 15 levels of subdirectories, then the lowest level cannot contain files, since these files would represent an additional level"
Of course I may completely have misunderstood or misinterpreted, in which case I look forward to being enlightened :blush:.
...
October 6, 2015 at 2:58 am
I misinterpreted the subdirectory question--I thought it meant you couldn't have more than 255 subdirectories at each level, rather than the nesting level? There used to be hard limits on the number of subdirectories you could create in the root of a FAT file system, for instance.
October 6, 2015 at 3:02 am
Great question, thanks!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 6, 2015 at 5:49 am
That was a really good question. Since I haven't worked with filetables yet (still on 2008) it took some reading of BOL and I learned new things, which is always good. Thanks, Andy.
October 6, 2015 at 6:12 am
Could you give an example where it would be useful to add a constraint to a FileTable?
October 6, 2015 at 6:59 am
The maximum number of subdirectories in a filetable is 255 and The maximum number of subdirectories is limited only by disk space are both incorrect.
should be
The maximum number of subdirectory levels in a filetable is 255 and The maximum number of subdirectory levels is limited only by disk space are both incorrect.
You can have as many subdirectories as you want as long as you don't go more than 15 deep.
October 6, 2015 at 7:15 am
The explanation:
The maximum number of subdirectories in a filetable is 255 and The maximum number of subdirectories is limited only by disk space are both incorrect. Strangely enough the limit is 15 and if you do create 15, you can't then create files in the bottom most folder!
is incorrect. There is no limit to the number of subdirectories in a filetable, though there is a limit to the number of levels
Gerald Britton, Pluralsight courses
October 6, 2015 at 7:44 am
Good question. Thanks!
October 6, 2015 at 8:54 am
A really good question on FileTables.
October 6, 2015 at 1:18 pm
So correct me if I am wrong but opinion is divided between "the answer is wrong" and "brilliant question learnt a lot!!". is there any real consensus on whether the subdirectory answer is right or wrong.
Call me confused but I thought the answer was wrong and still see no explanation of why it is right!! :unsure:
...
October 6, 2015 at 1:21 pm
The answer is correct but the question is wrong. The question asks "how many sub directories?" The correct answer to that is, "no limit". The answer "limit is 15" is correct if the question is "How deep can sub directories be nested?"
But that's not what was asked.
Gerald Britton, Pluralsight courses
October 6, 2015 at 2:51 pm
Just another reminder how easy it is to get it wrong when writing these!
October 6, 2015 at 10:57 pm
I was sure of the 1st option, but the 2nd was tricky and even hard to find upon searching.
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
Viewing 15 posts - 1 through 15 (of 18 total)
You must be logged in to reply to this topic. Login to reply