Forum Replies Created

Viewing 15 posts - 39,166 through 39,180 (of 59,098 total)

  • RE: The Missing Certification

    WayneS (3/30/2010)

    Kit G (3/30/2010)

    I just realized I'm not understanding the context of a word being used here. That word is "gamer".

    From the search I did on the Internet 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 30, 2010 at 12:26 pm

    #1142560

  • RE: Today's Random Word!

    sing4you (3/30/2010)

    soft-shelled crab roll

    BWAA-HAA!!! "First Wife". 😀

    --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 30, 2010 at 11:27 am

    #1142493

  • RE: The Missing Certification

    GSquared (3/30/2010)

    There is no way short of hiring someone and putting them to work, to fully verify that someone knows the skills they are claiming. None that's realistic, anyway.

    You've seen...

    --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 30, 2010 at 11:18 am

    #1142486

  • RE: Why Be an MCP?

    blandry (3/30/2010)

    I am tired of this debate and can only address it as I know it...

    The best DBAs that I have seen, worked with, or had work for me, DID...

    --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 30, 2010 at 6:54 am

    #1142149

  • RE: Datediff doubt

    gaurav-404321 (3/30/2010)

    I am using datediff functionm to calculate the days span between two dates

    SET @StartDate=cast('2010-01-26 00:00:00.000' as datetime)

    SET @EndDate=cast('2010-02-25 00:00:00.000' as datetime)

    SET @TotalDaysInSalaryPeriod= DATEDIFF(dd,@StartDate,@EndDate)

    this is giving 30 as output.

    But...

    --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 30, 2010 at 6:50 am

    #1142145

  • RE: Datediff doubt

    Um... no, Dugi. Don't use the 23:59:59.999 thing.

    There are two reasons. First, anything larger than 23:59:59.997 will round up to the next day. Second, with some 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 30, 2010 at 6:47 am

    #1142141

  • RE: Ranking columns

    markjrouse (3/30/2010)

    Hi, here is a sample and expected result

    A B ...

    --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 30, 2010 at 6:42 am

    #1142134

  • RE: Aggregation of records

    My recommendation is that you read the article at the first link in my signature line below.

    --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 30, 2010 at 6:38 am

    #1142126

  • RE: Split column values into multiple rows using sql

    sqluserr (3/30/2010)

    Please let me know if you need any other details.

    I already did. Please see my previous post on this thread.

    --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 30, 2010 at 6:30 am

    #1142119

  • RE: Best way to transpose multiple rows onto 1 row?

    Paul White NZ (3/30/2010)

    derrysql (3/30/2010)

    Thank you for this. What sort of structure would the 'Tally' table have?

    Details here: http://www.sqlservercentral.com/articles/67899/

    Notice: same author (Jeff Moden) as the Dynamic Pivot article I...

    --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 30, 2010 at 5:53 am

    #1142090

  • RE: The Missing Certification

    Gift Peddie (3/29/2010)

    All I want is please leave the doors open to all [font="Arial Black"]with the ability[/font].

    Exactly... 🙂

    --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 29, 2010 at 7:39 pm

    #1141884

  • RE: The Missing Certification

    dma-669038 (3/29/2010)

    CirquedeSQLeil (3/29/2010)

    Jeff Moden (3/29/2010)

    Lynn Pettis (3/29/2010)

    We would be interested in hearing your suggestons to address those concerns. To be honest, I think we are trying to put together something...

    --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 29, 2010 at 7:33 pm

    #1141882

  • RE: The Missing Certification

    dma-669038 (3/29/2010)

    Somebody was asking about statistics on certs...this is from Greg Low's blog, about a year ago, the counts are across the world.

    MCDBA SQL 2000 152086

    MCTS SQL 2005...

    --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 29, 2010 at 7:26 pm

    #1141878

  • RE: The Missing Certification

    Lynn Pettis (3/29/2010)

    Would you also dropping the requirement that anyone seeking the MCJ not have to have an MCITP, as that was also a requirement suggested, iirc.

    That's a really good...

    --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 29, 2010 at 7:23 pm

    #1141876

  • RE: The Missing Certification

    Lynn Pettis (3/29/2010)

    So, are you saying that we should all just forget degrees and certs? That the time and effort I put into earning my BS and MA degrees was...

    --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 29, 2010 at 7:16 pm

    #1141874

Viewing 15 posts - 39,166 through 39,180 (of 59,098 total)