Forum Replies Created

Viewing 15 posts - 49,591 through 49,605 (of 59,099 total)

  • 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

  • RE: The T-SQL Quiz

    Ummm... you think the use of a While loop is "elegant"? :blink: :Whistling:

    --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:32 am

    #835388

  • RE: How to design an optional unique constraint

    Stephanie Giovannini (6/27/2008)

    Hmmm... I suppose the second table is the best way to do it, if I'm allowed to do so. At least I now have ammunition.

    Sorry, Stephanie... I have...

    --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:30 am

    #835384

  • RE: Table Valued functions Vs Scalar Valued Functions

    TheSQLGuru (6/27/2008)

    At each of my last 3 SQL 2005 performance tuning/analysis client gigs I have addressed tremendous performance issues by removing the use of TVFs (and also table variables). ...

    --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:09 am

    #835365

  • RE: Grouping GROUP BY subtotals

    jcrawf02 (6/27/2008)

    Sergiy (6/27/2008)

    jcrawf02,

    can you explain this:

    ISNULL(count(distinct #PLANDATA_Claim.claimid),0) AS "FFS",

    What ISNULL is doing here?

    I have...

    --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:07 am

    #835363

  • RE: Grouping GROUP BY subtotals

    jcrawf02 (6/27/2008)

    Sorry, didn't use that in this example. What I ended up doing in my live version is this:

    LEFT JOIN #member ON (ISNULL(PLANDATA_Claim.enrollid,ENCOUNTER_Claim.enrollid) = #member.enrollid )

    Hmmmm.... I suppose 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 8:05 am

    #835361

  • RE: For loop in sql server

    Thanks for the feedback...

    --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:00 am

    #835358

  • RE: more elegant search

    Heh... wasn't me, Bill... I'm still trying stuff out...

    --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:54 am

    #835350

Viewing 15 posts - 49,591 through 49,605 (of 59,099 total)