Post reply

recommendation of tempb files

  • January 9, 2017 at 7:11 am

    #1921346

    Whoops didn't read page 2 of this post T1117 already mentioned.

  • January 11, 2017 at 7:56 am

    #1921952

    Talib123 (1/9/2017)

    Whoops didn't read page 2 of this post T1117 already mentioned.

    So was T1118. But, on the subject of T1117 and as I mentioned in a previous post on this thread, you have to be careful because it's a server-wide setting that will cause all files in all filegroups in all databases to grow to the same size all the time. Imagine your surprise when it totally wrecks your carefully planned file sizes for things such as partitioned tables and other places where you actually do want different file sizes within a single file group.

    Fortunately, it's been deprecated and, IIRC, removed from use in 2016.

    --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)

  • January 11, 2017 at 8:32 am

    #1921965

    Jeff,

    Very useful information. I didn't know that.

    Thanks.

    Talib

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply