Forum Replies Created

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

  • RE: Performance challenge

    hreisterp (12/28/2010)

    Thanks for your post. But that was not the challenge. Actually loading all prime number from a pre-computed list is MUCH faster (if it is not huge number 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)

    December 28, 2010 at 5:44 am

    #1266689

  • RE: Performance challenge

    hreisterp (12/28/2010)

    The performance challenge is not to insert the data but to select the prime number. 🙂

    Heh... I know... but if it takes you 6 seconds to create only 60,000...

    --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 28, 2010 at 5:42 am

    #1266688

  • RE: bcp or sp_send_dbmail

    asdfgh-617842 (12/27/2010)

    fixed the 'sp_send_dbmail .csv attachment Xcel not opening properly - putting all data in one column' issue with a small hack:

    in sp_send_dbmail, do:

    @query_attachment_filename = 'blah.csv'

    ,@query_result_separator = ' ...

    --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:17 pm

    #1266614

  • 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

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