BPE Limits

  • Comments posted to this topic are about the item BPE Limits

  • Good question to start the week, thanks Steve.

    ...

  • On a bit of a tangent, I find it ironic that BPE probably works best with SSDs and that SSDs may eliminate the need for BPE.  I know it's a bit different but it reminds me of the days of RAM Disk.

    The one place where I can really see this helping is if you have large tables that make use of GUIDs for keys, which have a super even distribution pattern throughout the length of the table.

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

  • Nice one to start the week on, thanks Steve

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

  • Not sure I like the sound of the "Bugger Pool Extnetion" as given in the answer!

  • Andrew Watson-478275 - Monday, January 28, 2019 2:12 AM

    Not sure I like the sound of the "Bugger Pool Extnetion" as given in the answer!

    Lol I thought I'll probably avoid taking a dip in that one...

  • thought i knew this, evidently i did not!,
    i do know though 🙂
    thanks

    ---------------------------------------------------------------------------------------
    The more you know, the more you know that you dont know

  • Explanation corrected. Apparently I was had an offset on my fingers last week.

Viewing 8 posts - 1 through 7 (of 7 total)

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