Forum Replies Created

Viewing 15 posts - 49,576 through 49,590 (of 59,091 total)

  • RE: The T-SQL Quiz

    Matt Miller (6/27/2008)

    I personally roll with a tally table with a 1M limit, but that's a personal choice.

    Otherwise - it's very easy to come up with a numbers table 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)

    June 27, 2008 at 10:45 pm

    #835712

  • RE: The T-SQL Quiz

    Oh no... about 99% of everything you need to do can be done with a Tally table of 11,000 rows. If you need more than that, you can 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)

    June 27, 2008 at 7:27 pm

    #835686

  • RE: T-sql question

    Aye. Thanks for the feedback... I sometimes wonder if posts like that do any good. 🙂

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

    June 27, 2008 at 6:36 pm

    #835679

  • RE: The T-SQL Quiz

    David Jackson (6/27/2008)

    Hats off to Jeff M for teaching us this trick

    Edit: I see Matt beat me to it, but he is spot on, forget loops if you can.

    Thanks...

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

    June 27, 2008 at 6:34 pm

    #835678

  • RE: Converting numbers

    Mark (6/27/2008)

    But I got errors.

    Can't read your mind, Mark... please post the exact text from the errors...

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

    June 27, 2008 at 6:30 pm

    #835677

  • RE: The T-SQL Quiz

    zxn001 (6/27/2008)

    Ok... so basically when you ask it to opperate a command on a column...

    THAT, is the basis of set based programming. THAT, is the necessary paradigm shift necessary...

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

    June 27, 2008 at 6:28 pm

    #835676

  • RE: The T-SQL Quiz

    dfalso (6/27/2008)

    Also, depending on need, you can adapt the above to dynamic SQL should you want to work with input parameters.

    Why would you need to do 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)

    June 27, 2008 at 6:25 pm

    #835675

  • RE: Tricky Transact SQL

    Michael has the right idea for you helping us to help you.

    In the meantime, lookup "Cross Join" in Books Online...;)

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

    June 27, 2008 at 12:29 pm

    #835574

  • RE: The T-SQL Quiz

    Tom Garth (6/27/2008)

    There are some assumptions in what I'm about to say.

    That's a heck of a good explanation, Tom...

    To put it in laymen's terms, there are two ways to buy...

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

    June 27, 2008 at 12:26 pm

    #835570

  • RE: The T-SQL Quiz

    zxn001 (6/27/2008)

    I didnt know SQL could do that.

    And you made me a believer, a very confused one, but still believing.

    So now I'm really curious, WHY does the set loop work...

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

    June 27, 2008 at 12:19 pm

    #835566

  • RE: I have a requirement like this?

    Basically, I use batch files to do the transfers like Matt suggested. You're moving files... why not let the thing that handles files the best do it... namely 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)

    June 27, 2008 at 12:12 pm

    #835558

  • RE: I have a requirement like this?

    Validation of the text files should be done either during the creation of the text file, during the import of the text file, or, preferably, both.

    And, yes... the copy 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)

    June 27, 2008 at 11:56 am

    #835548

  • RE: text file in sql

    To answer such a general question, I have to say lookup the following in Books Online...

    Bulk Insert

    BCP

    BCP Format Files

    Linked Servers (for text files)

    OpenRowSet

    DTS

    SSIS

    OSQL

    SQLCMD

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

    June 27, 2008 at 11:52 am

    #835546

  • RE: Do I need more memory?

    jjssilva (6/27/2008)

    What I ment was, in order to have maximum performance gain from the DB, it should be in memory. Usually around 80% is enough. You can have less memory...

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

    June 27, 2008 at 8:40 am

    #835395

  • RE: Do I need more memory?

    Matt Miller (6/27/2008)

    I keep waiting for my guys to install that 1 Exabyte RAMdisk I asked for. Just would make all of those nasty delays just melt away...I wonder...

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

    June 27, 2008 at 8:37 am

    #835394

Viewing 15 posts - 49,576 through 49,590 (of 59,091 total)