Forum Replies Created

Viewing 15 posts - 3,811 through 3,825 (of 59,087 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

  • Reply To: Can't Import File

    homebrew01 wrote:

    Eirikur Eiriksson wrote:

    Just a thought, start by importing the file as all character columns, then analyse the data and reconstruct the target table. 😎 I don't like the Import 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)

    March 8, 2022 at 2:31 am

    #3995399

  • Reply To: Can't Import File

    water490 wrote:

    Jeff Moden wrote:

    I think the following error line from those that you provided is the key hint as to what is wrong...

    Error 0xc02020c5: Data Flow Task 1: Data conversion failed...

    --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 7, 2022 at 9:49 pm

    #3995320

  • Reply To: performance question

    Jeffrey Williams wrote:

    All it indicates is that this query is called a lot - but if that execution is sub-second each time then you probably don't have an issue.

    Ah, careful now. ...

    --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 7, 2022 at 9:45 pm

    #3995319

  • Reply To: Restore SQL databae

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

    --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 7, 2022 at 6:07 am

    #3994583

  • Reply To: Can't Import File

    I think the following error line from those that you provided is the key hint as to what is wrong...

    Error 0xc02020c5: Data Flow Task 1: Data conversion failed while converting...

    --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 7, 2022 at 6:01 am

    #3994576

    • Viewing 15 posts - 3,811 through 3,825 (of 59,087 total)