Forum Replies Created

Viewing 15 posts - 17,461 through 17,475 (of 59,102 total)

  • RE: DBA career advice

    patrickmcginnis59 10839 (6/13/2016)

    Jeff Moden (6/10/2016)

    patrickmcginnis59 10839 (6/10/2016)

    RonKyle (6/9/2016)

    Besides, if you have to prepare for an interview, then you're not ready for the job.

    Disagree. It never hurts to review 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)

    June 18, 2016 at 1:31 pm

    #1885748

  • RE: Interview Questions

    Sergiy (6/17/2016)

    Jeff, if you're after a senior one then don't ask junior level questions.

    My remark was about this statement from you:

    the candidate probably shouldn't over-engineer the answer, especially 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)

    June 17, 2016 at 5:31 pm

    #1885729

  • RE: Insert Same rows Multiple times

    djacob 65569 (6/17/2016)

    THANK YOU!!! That helped me out immensely!

    The question now is, do you understand how and why it works?

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

    June 17, 2016 at 9:14 am

    #1885649

  • RE: Hunting down bad code/ETL

    As a bit of a sidebar and like anything else in SQL Server, saying something like the use of SELECT * always being bad is the wrong thing to say....

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

    June 17, 2016 at 8:55 am

    #1885645

  • RE: Simple CLR request

    Luis Cazares (6/17/2016)

    Just curious on why you want to use CLR for this.

    +1000

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

    June 17, 2016 at 8:49 am

    #1885642

  • RE: Interview Questions

    Ed Wagner (6/17/2016)

    Sergiy (6/16/2016)

    My point was - the question about finding current time does not have a correct answer without specifying additional conditions.

    And I think that's fine. If 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)

    June 17, 2016 at 7:25 am

    #1885601

  • RE: Are the posted questions getting worse?

    What's really incredible is how powerful integer math solutions can actually be depending, of course, on what you need to do. Sometimes the really old, simple stuff is 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)

    June 17, 2016 at 7:19 am

    #1885597

  • RE: help with "cast"

    rightontarget (6/16/2016)

    Not really, please explain

    To summarize, if all parts of an equation are of the INTEGER datatype (or any integer based datatype), all of the math will be done using...

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

    June 17, 2016 at 7:09 am

    #1885592

  • RE: Interview Questions

    Luis Cazares (6/16/2016)

    Jeff Moden (6/16/2016)

    timwell (6/16/2016)

    Sergiy (6/15/2016)

    My "Location" in the Forum Profile says "Auckland, New Zealand".

    Current time in Auckland, New Zealand is 12:12 pm.

    The "Posted" label indicates Today @ 1:12...

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

    June 16, 2016 at 6:43 pm

    #1885523

  • RE: Running Remaining Balance or Running Subtraction - Partition By Account

    venkyzrocks (6/8/2016)

    Thanks Guys. I was trying to avoid cursors and see if there was a faster solution. I completely detest cursors :), but I guess I had no option since...

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

    June 16, 2016 at 5:27 pm

    #1885522

  • RE: Date data manipulation.

    sql_2005_fan (6/10/2016)

    I need to run this query also on sql 2008 database and getting the following error on 2008.

    The Parallel Data Warehouse (PDW) features are not enabled.

    How can I rewrite...

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

    June 16, 2016 at 5:21 pm

    #1885520

  • RE: Identity insert without reseed

    kumarcug (6/15/2016)

    Hi,

    I found the answer after spend a whole day for POC,

    We need to connect to SSMS using "Replication=True" flag in the "Additaional Connection Parameters" tab of connection window. 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)

    June 16, 2016 at 1:52 pm

    #1885497

  • RE: Primary Node MSDb is not updatinng

    New persopn (6/15/2016)

    Hi All,

    In our environment we have a cluster setup and always on and we are performing Copy only backup in node 2 and similarly we have backup setup...

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

    June 16, 2016 at 1:37 pm

    #1885492

  • RE: help with "cast"

    rightontarget (6/16/2016)

    Hi all,

    I have a table with following data:

    idcnttotal

    20118015464

    233115464

    27615464

    282215464

    47415464

    I need to come up with 4th column that is: cnt/total, but it gives me 0.

    What do I need to "cast"...

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

    June 16, 2016 at 1:30 pm

    #1885490

  • RE: Interview Questions

    timwell (6/16/2016)

    Sergiy (6/15/2016)

    My "Location" in the Forum Profile says "Auckland, New Zealand".

    Current time in Auckland, New Zealand is 12:12 pm.

    The "Posted" label indicates Today @ 1:12 am.

    That's how I see...

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

    June 16, 2016 at 1:16 pm

    #1885488

Viewing 15 posts - 17,461 through 17,475 (of 59,102 total)