Forum Replies Created

Viewing 15 posts - 35,566 through 35,580 (of 59,099 total)

  • RE: Bulk Inserts

    purplebirky (12/27/2010)

    is there a why to filter this out durning my insert?

    Most likely not. Bulk Insert doesn't have any way to measure by criteria. Of course, that's...

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

    December 27, 2010 at 10:10 pm

    #1266613

  • RE: Performance challenge

    hreisterp (12/27/2010)

    Hello guys out there,

    here is a simple sounding but yet interesting challenge.

    Create a database with a single table named "numbers" with a single column of type int (or bigint).

    create...

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

    December 27, 2010 at 10:04 pm

    #1266612

  • RE: Convince me to upgrade to 2008

    Indianrock (12/27/2010)

    I'd like to hear more about netapp snap. At this point I'm not sure what is being planned for DR, except mention of some form of replicating...

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

    December 27, 2010 at 9:53 pm

    #1266611

  • RE: Update Query taking more then expected time

    vishal.sanu (12/27/2010)

    Dear All,

    Thanks for your valuable help

    Here is the changed Query ....

    UPDATE TEST1

    SET TEST1.INT_TBL_CODE = T2.INT_TBL_CODE,

    TEST1.CUST_CR_PREF_PCNT =T2.CUST_CR_PREF_PCNT,

    TEST1.ID_CR_PREF_PCNT =T2.ID_CR_PREF_PCNT ,

    TEST1.ID_DR_PREF_PCNT =T2.ID_DR_PREF_PCNT ,

    TEST1.MIN_INT_PCNT_CR=T2.MIN_INT_PCNT_CR,

    TEST1.MAX_INT_PCNT_CR =T2.MAX_INT_PCNT_CR,

    TEST1.END_DATE =T2.END_DATE,

    TEST1.PEGGED_FLG = T2.PEGGED_FLG,

    TEST1.INT_TBL_VER_NUM...

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

    December 27, 2010 at 5:52 pm

    #1266603

  • RE: Transpose Verticle to Horizontal

    pkaraffa (12/27/2010)

    Jeff Moden (12/26/2010)

    pkaraffa (12/26/2010)

    Thanks andrewd.smith that worked very well for a small amount of data (actually great) but I am dealing with over 500,000 rows and about a thousand...

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

    December 27, 2010 at 5:49 pm

    #1266602

  • RE: SQL2005 SP4 is here

    Steve Jones - SSC Editor (12/27/2010)

    I understand why there's a CU since the time it takes to assemble and test the SP means that another CU was assembled in 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)

    December 27, 2010 at 5:45 pm

    #1266601

  • RE: Partitioned Indexes

    mitch.fh (12/27/2010)

    Thanks for your advice.

    I would like to read sth out of the execution plan, but I do not see anything out of the index creation index plan 🙁 or...

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

    December 27, 2010 at 5:41 pm

    #1266600

  • RE: Calculating balance from previous row

    Hi Dilip,

    If you could post some test data (see the article at the first link in my signature line below to help us help you the best way) to go...

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

    December 27, 2010 at 7:35 am

    #1266440

  • RE: Update Query taking more then expected time

    While we're waiting for the Execution Plan...

    There's no way for the following to use an index because the columns have to be converted to the value inteneded by the formulas...

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

    December 27, 2010 at 7:26 am

    #1266439

  • RE: retrieve min date from criteria - tricky

    itfbd (12/27/2010)

    Thanks a lot experts, problem solved through your valuable advice.

    Thank you for the feedback. Would it be possible for you to post your final solution (or facsimile 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)

    December 27, 2010 at 6:11 am

    #1266419

  • RE: Edit a datetime field

    eyejay (12/27/2010)

    Jeeeez,

    What is it with you lot??????????

    You know nothing about exactly what this database holds or how it is managed or what happens to the data............

    I'm simply a newbie asking...

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

    December 27, 2010 at 6:08 am

    #1266417

  • RE: Transpose Verticle to Horizontal

    pkaraffa (12/26/2010)

    Thanks andrewd.smith that worked very well for a small amount of data (actually great) but I am dealing with over 500,000 rows and about a thousand different dates. LutzM...

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

    December 26, 2010 at 7:47 pm

    #1266351

  • RE: Edit a datetime field

    I agree with BitBucket on this one. If the machine is not producing the correct dates, it needs to go to the repair/calibration lab NOW! There's no telling...

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

    December 26, 2010 at 7:43 pm

    #1266350

  • RE: Convince me to upgrade to 2008

    Indianrock (12/26/2010)

    Our primary production database is SQL 2005 Enterprise 64-bit on a Server 2008R2 active/passive cluster. I'd like to propose ( sell ) an upgrade to sql 2008...

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

    December 26, 2010 at 7:35 pm

    #1266349

  • RE: Interview Que

    saidapur_satish (12/26/2010)

    Hi Jeff Moden,

    Thanks, but i am not get properly could you explain me main things commonly what DBA will do?

    Thanks & Regards

    Satish Saidapur

    People write...

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

    December 26, 2010 at 7:09 pm

    #1266348

Viewing 15 posts - 35,566 through 35,580 (of 59,099 total)