Forum Replies Created

Viewing 15 posts - 32,266 through 32,280 (of 59,099 total)

  • RE: simple one table query

    Here's my solution for the original problem. Keep in mind that I'm assuming from the original description of the problem that there are no more than three F2s for...

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

    October 16, 2011 at 1:05 pm

    #1395086

  • RE: simple one table query

    chandan_jha18 (10/15/2011)

    GilaMonster (10/15/2011)

    A temp table and 3 updates for what can be done in a single query? Not exactly the best option around for performance...

    Hi Monster,

    Are temp tables bad 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)

    October 16, 2011 at 10:34 am

    #1395080

  • RE: simple one table query

    erhanduman (10/15/2011)

    Hello;

    I have table;

    These values are

    F1F2

    621apple

    621orange

    622banana

    622grape

    622strawberry

    623apple

    623plum

    623melon

    624apple

    624strawberry

    I want convert this table.

    F1F2.2F2.2F2.3

    621appleorange

    622bananagrapestrawberry

    623appleplummelon

    624applestrawberry

    I'm tried with join and pivot table methods. But I can't do it. Is there any suggestion

    Thanks

    Erhan

    Erhan,

    The reason why 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)

    October 16, 2011 at 10:28 am

    #1395078

  • RE: simple one table query

    Performance Guard (Shehap) (10/15/2011)

    If huge data entity for table1 , please let me know to guide more about the best performance options

    That seems quite contrary to what you said after...

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

    October 16, 2011 at 10:10 am

    #1395077

  • RE: simple one table query

    Performance Guard (Shehap) (10/16/2011)

    Jeff ,

    To clarify more ....Thinking of all performance terms is the best way to keep your production servers healthy all the time....

    You're definitely preaching to the choir...

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

    October 16, 2011 at 10:05 am

    #1395075

  • RE: Typical DBA day...

    Ninja's_RGR'us (10/15/2011)

    Jeff Moden (10/15/2011)

    Ninja's_RGR'us (10/14/2011)

    Is [font="Arial Black"]that [/font]why you stopped being a manager and went back to "normal" DBA?

    Considering I covered several different topics in my post, is WHAT why?

    Micro...

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

    October 15, 2011 at 10:47 pm

    #1395035

  • RE: Typical DBA day...

    Just my personal opinion... I think that breakdown has already been accomplished and, for a team lead, the admin time for 3 DBA's seems about right to me especially 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)

    October 15, 2011 at 10:35 pm

    #1395034

  • RE: Inserting into large table

    Aspet Golestanian Namagerdi (10/15/2011)

    But it does not seems the problem is related to the l0op,When I remove the Select statment it workes pretty fast.Also when I used the xEvents here...

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

    October 15, 2011 at 10:20 pm

    #1395033

  • RE: simple one table query

    Performace Guard (Shehap) (10/15/2011)

    From performance view point :

    1.Create temp table commands are always better than declare temp table commands where temp clustered + non clustered index could be there as...

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

    October 15, 2011 at 10:16 pm

    #1395032

  • RE: Are the posted questions getting worse?

    GilaMonster (10/15/2011)

    Steve Jones - SSC Editor (10/15/2011)

    Not enough of a detailed explanation according to Gail as she was trying to throw a shuriken, or rubber duck, or something at me.

    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)

    October 15, 2011 at 10:04 pm

    #1395031

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (10/15/2011)

    GilaMonster (10/15/2011)

    Steve Jones - SSC Editor (10/15/2011)

    Not enough of a detailed explanation according to Gail as she was trying to throw a shuriken, or rubber...

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

    October 15, 2011 at 9:53 pm

    #1395030

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (10/15/2011)

    GilaMonster (10/15/2011)

    Steve Jones - SSC Editor (10/15/2011)

    Not enough of a detailed explanation according to Gail as she was trying to throw a shuriken, or rubber...

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

    October 15, 2011 at 9:47 pm

    #1395029

  • RE: Please Help !!!!

    sqldba2k8 (10/15/2011)

    At present iam in hyderabad.I was completed my sql server dba course in one of the worst institute in hyderabad.

    Please provide me the learning material or books for sql...

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

    October 15, 2011 at 12:25 pm

    #1394990

  • RE: Problem with sp_cursorfetch performance

    Gugro (10/15/2011)

    Todd Engen (3/6/2008)

    I've seen that that behavior before and it was an application issue;in query analyzer it took less than a second to return the results, from the application...

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

    October 15, 2011 at 12:17 pm

    #1394985

  • RE: simple one table query

    erhanduman (10/15/2011)

    I'm tried with join and pivot table methods. But I can't do it. Is there any suggestion

    Thanks

    Erhan

    Cool... show us the code you tried and we'll show where you may...

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

    October 15, 2011 at 12:06 pm

    #1394981

Viewing 15 posts - 32,266 through 32,280 (of 59,099 total)