Filetable Trivia

  • Comments posted to this topic are about the item Filetable Trivia

  • This was removed by the editor as SPAM

  • 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:.

    ...

  • 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.

  • Great question, thanks!

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • 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.

  • Could you give an example where it would be useful to add a constraint to a FileTable?

  • 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.

  • 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

  • Good question. Thanks!

  • A really good question on FileTables.

  • 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:

    ...

  • 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

  • Just another reminder how easy it is to get it wrong when writing these!

  • 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