Home Forums SQL Server 2016 SQL Server 2016 - Administration Help me in designing table and its indexes RE: Help me in designing table and its indexes

  • March 3, 2018 at 5:52 pm

    #1981864

    DesNorton - Saturday, March 3, 2018 1:00 PM

    I would also consider separating Directories and Files into their own tables.

    I'll suggest against putting those into their own tables.  It would be like putting managers and employees in their own tables, which pretty much screws the whole notion of the hierarchy.

    If you have the files and directories in the same table, then you can also use the method in the article at the second link to get byte totals for all levels of all directories.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)