Forum Replies Created

Viewing 15 posts - 3,781 through 3,795 (of 59,067 total)

  • Reply To: Availability Group - Data Import problems

    Jeffrey Williams wrote:

    Now - with all that said, loading 120K rows shouldn't take more than a couple of minutes at most. The fact that it already takes several hours I would...

    --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 8, 2022 at 3:27 am

    #3995409

  • Reply To: Restore SQL databae

    Eirikur Eiriksson wrote:

    Jeff Moden wrote:

    Apparently, this isn't an urgent problem, eh?

    Guess someone is RTFM'ing 😉 ;cool:

    That would be a nice change.

    --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 8, 2022 at 3:14 am

    #3995406

  • Reply To: SSRS - How to configure date in report in usa

    Jeffrey Williams wrote:

    Another option

    WHERE YourDateColumn >= DATEADD(month, DATEDIFF(month, 0, GETDATE()) - 1, 0)  --First of previous month
    AND YourDateColumn < DATEADD(month, DATEDIFF(month, 0, GETDATE()), 0)  --First of...

    --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 8, 2022 at 3:13 am

    #3995405

  • Reply To: SSRS - How to configure date in report in usa

    Ant-Green wrote:

    So you will want to do some date math.

    You should treat all dates as the ISO standard and to avoid any ambiguity use YYYY-MM-DD formatting when passing dates 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 8, 2022 at 3:05 am

    #3995404

    • Viewing 15 posts - 3,781 through 3,795 (of 59,067 total)