Forum Replies Created

Viewing 15 posts - 38,596 through 38,610 (of 59,098 total)

  • RE: convert month name to month number

    madhu.gut (5/6/2010)

    Hi All

    How should i convert the month name to month number like

    'April' it should converted to 4

    'January' it should converted to 1

    in this how should i do this

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

    May 6, 2010 at 8:55 pm

    #1163757

  • RE: What is the most efficient way to delete records?

    brutsoft (5/6/2010)

    Jeff Moden (5/6/2010)

    How many indexes do you have on this bad boy? Also, do you have any Foreign Keys or triggers associated with this table?

    Out of 180GB occupied...

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

    May 6, 2010 at 8:45 pm

    #1163756

  • RE: MAXDOP

    Bhuvnesh (5/6/2010)

    Chinna-703814 (5/6/2010)

    how do we set it for sql server 2005

    and more important why we need to set it up ?

    As well as what Leo said, sometimes the costs...

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

    May 6, 2010 at 8:38 pm

    #1163755

  • RE: SQL Server Aggregation Query - Help needed

    riyaz.mohammed (5/6/2010)

    Hi that worked great for the example i provided. If i add another requirement into the mix what would the SQL look like?

    SEQUENCE,PRODUCT,TIME,PRICE

    1,Spoon1,2010-05-05 08:30:00.000,83.50

    2,Spoon1,2010-05-05 08:31:01.000,80.00

    3,Spoon1,2010-05-05 08:32:02.000,81.00

    4,Spoon1,2010-05-05 08:33:03.000,82.00

    5,Fork1,2010-05-05 08:31:01.00,90.50

    6,Fork1,2010-05-05...

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

    May 6, 2010 at 8:24 pm

    #1163751

  • RE: Using the result of a function in the retrned values & where-clause

    Although it's a bad practice to use "*", it's not really going to matter here. Sargeability has already been destroyed by the function and it's not a view that...

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

    May 6, 2010 at 8:05 pm

    #1163744

  • RE: What is the most efficient way to delete records?

    brutsoft (5/6/2010)

    And here the first million with the new script:

    13122010-05-07 12:32:35.697

    13012010-05-07 12:01:39.113

    If I have 1 mil deleted every half an hour I'll need >70 more hours to finish the delete...

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

    May 6, 2010 at 7:53 pm

    #1163740

  • RE: What is the most efficient way to delete records?

    Leo.Miller (5/6/2010)

    You asked: Why are you saying that to find the TOP (1000000) sql must check all the records?

    The only way to find the TOP record is to look at...

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

    May 6, 2010 at 7:44 pm

    #1163738

  • RE: Help with Query

    Between the sample data, the sample output, and the description, it was a pleasant change for me. I'll tolerate nuances of the language barrier for postings like this one.

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

    May 6, 2010 at 7:17 pm

    #1163733

  • RE: Advantage of Using Constraint when adding FK or PK

    PaulB-TheOneAndOnly (4/26/2010)

    Jeff Moden (4/23/2010)

    If the table is a Temp Table, there's actually a DISADVANTAGE to using CONSTRAINT to name the PK... a constraint is one of those objects whose name...

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

    May 6, 2010 at 6:14 pm

    #1163725

  • RE: Allowing access to tempdb

    Gosh... I'm not sure how to help. Generally, everyone has access to TempDB and should be able to read TempDB.sys.Objects. I'm also surprised that if the GUI is...

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

    May 6, 2010 at 6:01 pm

    #1163720

  • RE: Training for Managers

    Lynn Pettis (5/6/2010)

    CirquedeSQLeil (5/6/2010)

    Lynn Pettis (5/6/2010)

    Jeff Moden (5/5/2010)

    Something that people either aren't aware of or have forgotten... the option of in-house training by the resident experts is a powerful...

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

    May 6, 2010 at 5:40 pm

    #1163718

  • RE: Training for Managers

    jcrawf02 (5/6/2010)

    ask people for topics they'd like to see, there may be things they're working on that they can use help with.

    That's an outstanding idea. Just keep in mind...

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

    May 6, 2010 at 5:19 pm

    #1163714

  • RE: Missing numbers in a series

    Paul White NZ (5/6/2010)

    Jeff Moden (5/6/2010)

    Yep... I remember the "other" triangular join. You made it to be very fast but it still ended up doing the same number 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)

    May 6, 2010 at 4:48 pm

    #1163694

  • RE: Missing numbers in a series

    Paul White NZ (5/6/2010)

    Ok, here's the quick 'n' dirty CLR aggregate:

    Ooooohhhhh mmmmyyyyy ggggooooodddd... someone that actually knows what "//" is for.

    Very well done Mr. White.

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

    May 6, 2010 at 4:45 pm

    #1163693

  • RE: Training for Managers

    AspiringGeek-40457 (5/6/2010)

    "The only thing worse than training everyone and having some of them leave is not training any of them and having them all stay."

    --Zig Ziglar

    I love it...

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

    May 6, 2010 at 12:28 pm

    #1163510

Viewing 15 posts - 38,596 through 38,610 (of 59,098 total)