Forum Replies Created

Viewing 15 posts - 6,301 through 6,315 (of 59,072 total)

  • Reply To: Index Fragmentation

    stevec883 wrote:

    In your comment about the fill factor, "All the pages you see at the 70% line are stuck at 70% FOREVER." I

    If I change this fill factor to 100%...

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

    September 28, 2020 at 10:06 pm

    #3791454

  • Reply To: Stored Procedure Performance Woes... How to get around CURSORS for html gen.

    The key here is to always remember what's important in these types of things... it's massively important, even if all the code is done in T-SQL, to keep the data-layer...

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

    September 28, 2020 at 10:02 pm

    #3791453

  • Reply To: A Getting Started PostgreSQL Tutorial

    BWAAAA-HAAAAA!!! Nice tutorial but I find it odd to see a Postgre tutorial on a site names after SQLServer. 😉

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

    September 28, 2020 at 2:20 pm

    #3791327

  • Reply To: Are the posted questions getting worse?

    Sergiy wrote:

    So, it uses the same kind of lookup table but stored in Windows Registry.

    Not sure how gods is it in terms of performance, but it does not eliminate the...

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

    September 28, 2020 at 2:13 pm

    #3791325

  • Reply To: Size of table

    ... post deleted.  Accidental duplicate.

     

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

    September 28, 2020 at 2:07 pm

    #3791324

  • Reply To: Size of table

    .. post deleted.  Didn't see the OP's latest post.

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

    September 28, 2020 at 2:06 pm

    #3791323

  • Reply To: Size of table

    It's a shame that the OP didn't explain how they determined the table size.

    carsten.saastamoinen wrote:

    You can get the information from this select-statement. It shows the size of the table and...

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

    September 28, 2020 at 1:45 pm

    #3791310

    • Viewing 15 posts - 6,301 through 6,315 (of 59,072 total)