Forum Replies Created

Viewing 15 posts - 3,826 through 3,840 (of 59,098 total)

  • Reply To: Parse the string value

    Multiple CROSS APPLYs do add a tiny bit of overhead and, in this case, a fair bit of complexity.  We can simplify Thom's good code a bit by cascading 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 9, 2022 at 6:15 am

    #3996102

  • Reply To: performance question

    Bruin wrote:

    I found the offending query when I look at the Query Plan.

    Type conversion in expression (CONVERT_IMPLICIT(int,[d2].[attValue],0)) may affect "CardinalityEstimate" in query plan choice.

    How do I go about fixing..

    THanks.

    --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:51 am

    #3995423

  • 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

  • Reply To: What is SQL & how it wordk

    Just try asking that same question on Google or any search engine.  It's a common question and there are a shedload of excellent articles on the subject.

    --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 5:52 am

    #3994569

  • Reply To: Does SQL 2012 support computed fields?

    Ah, be careful now.  If you use a formula for the backbone of your computed "field" (they usually referred to as a computed or calculated "column") and it has any...

    --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 3:38 am

    #3994506

  • Reply To: performance question

    Bruin wrote:

    I did want to mention that this machine is a 2 node(8 cores per) machine and the Cost Threshold for Parallelism is set to 50. Maxdop on server basis...

    --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 2:59 am

    #3994494

  • Reply To: Lots of data + HierarchyId performanceproblems

    oRBIT - I finally figured some stuff out and used and old example of a small hierarchy and converted it to HIERARCHYID.  The "ID" column in your table is a...

    --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, 2022 at 11:26 pm

    #3994078

    • Viewing 15 posts - 3,826 through 3,840 (of 59,098 total)