Forum Replies Created

Viewing 15 posts - 121 through 135 (of 59,067 total)

  • Reply To: Alternatiives to Junk Dimensions

    Are you sure they said "junk" and not "jump"?  There is good use for tables that only contain IDs from the Fact Tables and the Dimension tables.  In relational databases,...

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

    March 12, 2025 at 6:43 pm

    #4558116

  • Reply To: Backup taking too much time

    My inline responses are in Bold'n'Black print below....

    VastSQL wrote:

    Thank you Jeff, Please find my inline response below.

    Jeff Moden wrote:

    If those backup drives are on the same system as your SQL Server,...

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

    March 12, 2025 at 5:58 pm

    #4558077

  • Reply To: Backup taking too much time

    EdVassie wrote:

    From your command it looks like you are using SQL native backup. There are other backup products out there (eg SQL Litespeed) that have as part of their USP...

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

    March 12, 2025 at 5:37 pm

    #4558063

  • Reply To: Dynamic T-SQL Script Parameterization Using Python

    You can always tell when a new article is going to be popular when the SPAM hits the discussion on it two weeks prior to the date it's supposed to...

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

    March 12, 2025 at 4:59 pm

    #4558030

  • Reply To: Are the posted questions getting worse?

    Grant Fritchey wrote:

    Reviving 10 year old zombie threads should probably be a no-no.

    If it provides a good answer, especially a more effective good answer, I don't mind.  It'll help others when...

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

    March 6, 2025 at 9:53 pm

    #4552897

  • Reply To: Deadlocks after index rebuild

    btork wrote:

    @jeff - a lot of this rings true with me and this situation. My real challenge is how do I move forward. Should I update the stats for 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)

    March 5, 2025 at 10:19 pm

    #4552115

  • Reply To: Deadlocks after index rebuild

    btork wrote:

    We rebuilt a bunch of indexes that had avg_fragmentation_in_percent>30.

    This will sound odd but you probably won't get much useful data from the deadlock data other than you're now suffering...

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

    March 5, 2025 at 5:18 pm

    #4551942

  • Reply To: Unable to delete records from table

    narayanamoorthy.a wrote:

    Yes well noted and conveyed the same to business and application owners. They are well are of the repercussions and will take a call on this. Thank you all...

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

    March 3, 2025 at 3:47 pm

    #4550163

  • Reply To: Upgrading from SQL Server 2016 to 2022

    zoggling wrote:

    Thank you, have you managed to get past the performance issues as a result of the version upgrade? Do you possibly have any links you can share on why...

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

    March 3, 2025 at 3:39 pm

    #4550162

  • Reply To: KB5046856 fails to install

    The error is telling you what is wrong.  Also, if you go to the KB article, it will also tell you what is wrong.  It's saying that the instances where...

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

    March 3, 2025 at 1:56 am

    #4549576

  • Reply To: Announcing SQL Server 2025

    I just want them to fix the serious performance problems that started in 2019 and they've done (apparently) nothing to fix even up 'til today for SQL Server 2022. 🙁

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

    March 1, 2025 at 2:01 am

    #4548499

  • Reply To: Upgrading from SQL Server 2016 to 2022

    Yes... but it won't help... Stand up your 2022 server and do some restores and then do test runs against your old server and the new one.  The tests should...

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

    February 28, 2025 at 6:49 pm

    #4548299

  • Reply To: Unable to delete records from table

    Heh... and people wonder why such a thing won't stand up in court.  Ant-Green is spot on!

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

    February 26, 2025 at 11:42 pm

    #4546853

    • Viewing 15 posts - 121 through 135 (of 59,067 total)