Forum Replies Created

Viewing 15 posts - 4,786 through 4,800 (of 59,070 total)

  • Reply To: Suppress Backup Messages In Logs

    RonMexico wrote:

    It is Dell Data Domain Boost

    Thanks, Ron.

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

    August 18, 2021 at 2:43 pm

    #3921403

  • Reply To: Migrate On-prem DB

    Lordy.  Thanks for the feedback and good to "see" you again.

    I also love the short story in your signature line.  The only problem with either books or "GIYF" is that...

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

    August 18, 2021 at 2:37 pm

    #3921402

  • Reply To: YTD Date calculation

    Heh... Yeah... understood there.   I have the same feeling about FORMAT except that FORMAT is actually a performance issue on top of everything else.

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

    August 18, 2021 at 1:11 pm

    #3921270

  • Reply To: Are the posted questions getting worse?

    Heads up, folks.  Norton Life Lock lit up big time on the following breach.  It looks pretty serious...

    https://www.wired.com/story/t-mobile-hack-data-phishing/

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

    August 18, 2021 at 12:42 pm

    #3921250

  • Reply To: Migrate On-prem DB

    I've heard of so many such limits, missing features, and other problems having to do with Azure, I have to seriously wonder two  things...

    1. What the hell is Microsoft thinking?

      2. ...

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

    August 18, 2021 at 12:24 pm

    #3921240

  • Reply To: Create a delta from downloaded info

    ScottPletcher wrote:

    Jeff Moden wrote:

    Invoice line items can have a ship date

    Only with a bad data model.  Parts from the same invoice line could be shipped on different dates.  You...

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

    August 18, 2021 at 6:22 am

    #3921154

  • Reply To: YTD Date calculation

    ScottPletcher wrote:

    I don't see the need for all that, this is much simpler:

    SET @ytdfrDate = DATEFROMPARTS(YEAR(@frdate) - 
        CASE WHEN MONTH(@frdate) < 4 THEN...

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

    August 18, 2021 at 6:03 am

    #3921150

  • Reply To: Create a delta from downloaded info

    ScottPletcher wrote:

    Jeff Moden wrote:

    Bruin wrote:

    With the same Line,subline?

    Look at the PK you've chosen.  IMHO, only the first 3 columns of InvoiceNbr, Line, and SubLine should make up the PK.

    I'm more confused...

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

    August 18, 2021 at 4:53 am

    #3921131

  • Reply To: Performance tuning

    sqlfriend wrote:

    unfortunately it is not something simple that T-SQL can handle. There are complicated logic to calculate stop corners according to time and direction of the bus etc, that is...

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

    August 18, 2021 at 4:48 am

    #3921128

  • Reply To: Performance tuning

    sqlfriend wrote:

    SSIS only has one execute task that  calls the web service.  I run today, there are 2000 routes to process, it runs about 8 hours on dev, and 10...

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

    August 18, 2021 at 12:03 am

    #3921077

  • Reply To: YTD Date calculation

    Ok... assuming the following requirements...

    1. Given any DATETIME value, calculate the starting date of the Fiscal Year the value falls into.
    2. The Fiscal year starts on the 1st of April.

    In...

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

    August 17, 2021 at 11:28 pm

    #3921067

    • Viewing 15 posts - 4,786 through 4,800 (of 59,070 total)