Forum Replies Created

Viewing 15 posts - 32,026 through 32,040 (of 59,099 total)

  • RE: Starting with "WITH"

    SQL Kiwi (11/6/2011)

    Recursive CTEs can be made to perform extremely well;...{snip}...And there's also a 'super-fast' DISTINCT (by me!) that Jeff may recall:

    http://www.sqlservercentral.com/Forums/FindPost1013407.aspx

    That is a remarkable bit of code, indeed. ...

    --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, 2011 at 9:18 pm

    #1403768

  • RE: Starting with "WITH"

    SQLRNNR (11/6/2011)

    Jeff Moden (11/5/2011)

    SQLRNNR (11/3/2011)

    Yes recursive CTEs can be slow - you need to be sure you have defined your recursion well enough.

    I have seen them perform marvelously as well....

    --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, 2011 at 7:59 pm

    #1403763

  • RE: Big Data, Many Challenges

    MonkeyMan (11/5/2011)

    Whilst the performance of our existing DW in mix of SQL Server 2000/2008 is poor due to incremental developments over time by a host of consultants without any over-arching...

    --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, 2011 at 7:22 pm

    #1403761

  • RE: Formating numbers

    Thanks for taking the time to provide the feedback. Based on what you said, unless rounding is somehow important to that other stored procedure, I wouldn't bother formatting 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, 2011 at 4:38 pm

    #1403754

  • RE: Grouping on month

    JonFox (11/6/2011)

    That's great stuff Jeff! I love this forum, I keep learning better ways to do things. 🙂

    Thanks Jon, but I have to really stop typing at 2 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)

    November 6, 2011 at 4:31 pm

    #1403752

  • RE: Grouping on month

    SQL Kiwi (11/6/2011)

    Jeff Moden (11/6/2011)

    My main purpose in this is to show that what SQL Server labels as a SCAN is frequently a SEEK in disguise.

    The query plan I 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, 2011 at 4:26 pm

    #1403751

  • RE: Grouping on month

    You folks know me... I'll be one of the first to use a "Pseudo-Calendar" table if it's warrented. I don't believe it is in this case. We also...

    --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, 2011 at 12:38 am

    #1403683

  • RE: Inserting records into a large table

    richard garth (11/5/2011)

    What if it takes on 10 minutes to insert the extra records with the indexes intact, but it takes up to 3 hours to re-build the indexes after...

    --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 5, 2011 at 3:55 pm

    #1403671

  • RE: Comparing strings

    Beginner_2008 (11/5/2011)

    See table 1 has

    id,

    firstname,

    lastname,

    transactionamount

    table2 has

    id,

    fullname,

    transactionamount

    How to compare the firstname,lastname with fullname

    And after comaprision check whether the full name is 70% of the the both firrstname and lastname.

    Example:

    firstname: William

    lastname: John

    Fullname:...

    --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 5, 2011 at 3:46 pm

    #1403670

  • RE: Formating numbers

    amigoface (11/5/2011)

    well ,

    the context : i have to migrate a database appliation from firebird to SQL server

    the original database contain a stored procedure that use a formating function that doesn't...

    --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 5, 2011 at 3:40 pm

    #1403669

  • RE: best method to handle SCD

    For us, it was important that any change made by any method had to be detected and that the appropriate rows where enddated as part of the transaction that did...

    --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 5, 2011 at 9:29 am

    #1403630

  • RE: Starting with "WITH"

    SQLRNNR (11/3/2011)

    Yes recursive CTEs can be slow - you need to be sure you have defined your recursion well enough.

    I have seen them perform marvelously as well. For instance...

    --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 5, 2011 at 8:38 am

    #1403624

  • RE: Cursor

    You could, indeed. But way back when, someone suggested that FAST FORWARD isn't as fast as naming the options separately. I did a test back then and they...

    --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 4, 2011 at 11:48 pm

    #1403584

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (11/4/2011)

    SQL Kiwi (11/4/2011)

    So, it depends

    Someone so needs to come up with an interview question where this is the exact answer that's needed.

    @=)

    No problem... "I'm old... what am I...

    --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 4, 2011 at 11:34 pm

    #1403579

  • RE: Select the document name from a column contaning full path and file name

    Thanks for the feedback, Steve.

    Yeah... most of the "old hands" at this really like it a lot when someone takes the time to post readily consumable data. Saves 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 4, 2011 at 11:26 pm

    #1403577

Viewing 15 posts - 32,026 through 32,040 (of 59,099 total)