Forum Replies Created

Viewing 15 posts - 45,856 through 45,870 (of 59,101 total)

  • RE: Why do people need to do this?

    Piotr Rodak (1/16/2009)

    I came across the 'top 5' requirement. I needed to identify rows that have some values not smaller than 5 biggest values in the table. I guess it'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)

    January 16, 2009 at 7:18 pm

    #928614

  • RE: Hidden RBAR: Triangular Joins

    TheSQLGuru (1/16/2009)

    Tempdb constraints come to mind here. 🙂

    I sure do wish someone with CLR knowhow (and some free time) would take the opportunity to do some CLR code 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)

    January 16, 2009 at 5:15 pm

    #928597

  • RE: SQL Bulk Insert

    Does the target table exist to begin with?

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

    January 16, 2009 at 4:59 pm

    #928594

  • RE: Indexed View ... Slow !?!?

    There is no need for a cross-join on the date table to get all of the dates... it should be an outer join, instead. That is likely your performance...

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

    January 16, 2009 at 4:53 pm

    #928593

  • RE: Hidden RBAR: Triangular Joins

    TheSQLGuru (1/16/2009)

    Jeff, it strikes me that pretty much all of your examples here and in other threads have a clustered index on the key of concern. What happens when...

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

    January 16, 2009 at 4:45 pm

    #928588

  • RE: Which SQL would run faster?

    I must have something whacky going on with my machine... it gives me an XML error when I try to open the excecution plan.

    I have no doubt that the IO...

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

    January 16, 2009 at 4:34 pm

    #928587

  • RE: Why do people need to do this?

    noeld (1/16/2009)

    Answer: Because pigs can fly!

    LOL! Oh Lordy, that's what I'm starting to think about the reasons behind this problem. 😛

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

    January 16, 2009 at 3:34 pm

    #928571

  • RE: working with multiple dataset withing a table in SSRS

    Jeff Moden (1/13/2009)

    bsrlong (1/13/2009)

    As soon As I do find a solution I will not just post a reply I will attempt to have a document available.

    I am certainly looking forward...

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

    January 16, 2009 at 3:28 pm

    #928569

  • RE: Why do people need to do this?

    Lynn Pettis (1/16/2009)

    The excuse I usually here is this:

    It's easier to create and transfer one file instead of multiple files.

    Now THAT I get! It's a bit strange in how...

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

    January 16, 2009 at 3:14 pm

    #928555

  • RE: Why do people need to do this?

    Lowell (1/16/2009)

    clearly any data without an arbitrary number next to it is worthless! everyone knows that! how else do you know who's number 1, or to give a goals to...

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

    January 16, 2009 at 3:11 pm

    #928552

  • RE: Why do people need to do this?

    Matt Miller (1/16/2009)

    If you were a marketing person for CDW - knowing what the top five selling products are within each sales department would be something important. The last...

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

    January 16, 2009 at 3:09 pm

    #928548

  • RE: Why do people need to do this?

    Luke L (1/16/2009)

    ...to put into a flat file full of repeating groups to send to another organization.

    Heh.. that's what you did... my question would be, why did they want 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)

    January 16, 2009 at 3:05 pm

    #928546

  • RE: Evaluate a string Expression

    ramsatish (1/15/2009)

    Hi Michael Earl ,

    Thank you for the quick reply.

    How we are going to achieve this using CLR procedure.

    Is there any method/funtion available in CLR(SSIS) like "eval" to evaluate 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)

    January 16, 2009 at 2:29 pm

    #928532

  • RE: Evaluate a string Expression

    ramsatish (1/15/2009)

    Hi,

    I have a table which has expression as a column and the data looks similar to the following .

    ID (int) ...

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

    January 16, 2009 at 2:16 pm

    #928523

  • RE: SQL or Oracle

    hb21l6 (1/16/2009)

    It would appear that I have made a bit of a stir with this question. Sorry all,

    I think I’ll just stick at my MS SQL. Should be ready to...

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

    January 16, 2009 at 1:34 pm

    #928497

Viewing 15 posts - 45,856 through 45,870 (of 59,101 total)