Forum Replies Created

Viewing 15 posts - 41,266 through 41,280 (of 59,102 total)

  • RE: LEFT JOIN problem

    pc131 (11/6/2009)

    Hi

    Actually it was MySQL 5 issue, but I was looking for high traffic forums, so i put it here.

    Thanks

    Heh... that's like standing in traffic to see if you'll get...

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

    November 6, 2009 at 9:50 pm

    #1076230

  • RE: Is there a way to see the cost of a CASE statment

    Dave Ballantyne (11/6/2009)

    Absolutely. If you are doing performance comparisons, use millions of rows. One or two iterations really dont prove anything.

    Should be simple enough to do.

    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)

    November 6, 2009 at 9:47 pm

    #1076228

  • RE: Performance Expectations w/ Transactional Replication

    Ian Scarlett (11/6/2009)

    Jeff Moden (11/5/2009)

    Most of it is all very, very fast because it uses BCP behind the scenes.

    Are you sure, Jeff?

    I know the initial snapshot uses BCP, but (unless...

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

    November 6, 2009 at 9:37 pm

    #1076226

  • RE: Exporting Data from SQL Server

    Jeff Moden (11/6/2009)

    Bridget Elise Nelson (11/6/2009)

    Thanks. That sounds like a very good idea. I will be trying that.:-)

    Thanks for the feedback... If you have the time, please let us know...

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

    November 6, 2009 at 9:32 pm

    #1076225

  • RE: Exporting Data from SQL Server

    lmu92 (11/6/2009)

    Button (im)pressed. Nice one, Jeff!

    I thought there was an easy solution out there...

    Thanks Lutz. I love the "old" ways... so simple... 😀

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

    November 6, 2009 at 9:24 pm

    #1076224

  • RE: Exporting Data from SQL Server

    Bridget Elise Nelson (11/6/2009)

    Thanks. That sounds like a very good idea. I will be trying that.:-)

    Thanks for the feedback... If you have the time, please let us know how 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)

    November 6, 2009 at 9:21 pm

    #1076222

  • RE: Using OPENROWSET to import CSV files

    Simon Parry (11/6/2009)

    Hi

    i have tried using BULK INSERT

    using

    set @string ='BULK INSERT CSVTest FROM ''\\10.1.2.107\rp_uploaded_files\'+@file+''' WITH (FIELDTERMINATOR = '','',ROWTERMINATOR = '''')'

    exec (@string)

    but this requires the destintation table to have 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)

    November 6, 2009 at 9:18 pm

    #1076221

  • RE: Inspiring Change

    laurav (11/6/2009)

    I could not disagree more. I work with plenty of brilliant women who fall under the "genius" category. And I don't think the men "choose" who will...

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

    November 6, 2009 at 9:10 pm

    #1076220

  • RE: Inspiring Change

    Bob Hoffman-209065 (11/6/2009)

    Oh Steve, I think you need to come off the farm for a while and get reacquainted with life in the city. It's not an empolyee favored...

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

    November 6, 2009 at 9:04 pm

    #1076217

  • RE: Import data from csv file

    Dr.D (11/6/2009)

    It is not about a job interview nor university final exam nor homework. This is my task at work and i have 3 days to finish it. Yesterday 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)

    November 6, 2009 at 8:48 pm

    #1076216

  • RE: Money vs. Decimal Data type

    repent_kog_is_near (11/4/2009)

    Hi

    Float always gives the result of the calculator. That is why I assumed that Float will always be accurate. Can you give an example when Decimal gives...

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

    November 6, 2009 at 8:45 pm

    #1076214

  • RE: Looping through a directory for sub-directories' names

    ktlady (11/6/2009)

    Is there any way to do the sub-directory search inside SSIS package without having to involve database? Thanks!

    Probably, but I don't know because I don't use SSIS. I've...

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

    November 6, 2009 at 8:34 pm

    #1076213

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (11/6/2009)

    Luke L (11/6/2009)

    jcrawf02 (11/6/2009)

    So then we've finally found a definitive benefit of RBAR - environment control

    Jeff's gonna be pissed...

    Though I suppose if you get it to raise the temps...

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

    November 6, 2009 at 8:28 pm

    #1076211

  • RE: Running Totals

    Lynn Pettis (11/6/2009)

    First, watch SSC for Jeff's rewritten article on Running Totals. IIRC, it is coming out on 11/10/2009. It will be extremely enlightening.

    With that, here is a...

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

    November 6, 2009 at 4:41 pm

    #1076184

  • RE: Running Totals

    wizard5203 (11/6/2009)

    Jeff, thanks for the reply. You could tell from the post I'm a newbie. I looked at your link and will follow it on the next post. Thanks again.

    Heh......

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

    November 6, 2009 at 4:17 pm

    #1076175

Viewing 15 posts - 41,266 through 41,280 (of 59,102 total)