Forum Replies Created

Viewing 15 posts - 47,776 through 47,790 (of 59,099 total)

  • RE: Return all rows where one is a match

    Garadin (10/13/2008)

    I think we're gonna have to run this on significantly more data, and with varying population of the records returned by the subquery to really examine this... although 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)

    October 13, 2008 at 9:36 am

    #884236

  • RE: Return all rows where one is a match

    Not a good thing to do... the Percentage of Batch is highly unreliable and frequently absolutely incorrect...

    Look at the Percentage of Batch on the following code... then run it... SURPRISE!...

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

    October 13, 2008 at 9:09 am

    #884204

  • RE: Delete Duplicate values

    Kenney Hill (10/11/2008)

    Thank you Jeff.

    And thanks for pointing out the RBAR aspect of recursive queries. I'm still not very good at spotting hidden RBAR, and you are the master...

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

    October 13, 2008 at 8:34 am

    #884178

  • RE: Return all rows where one is a match

    Garadin (10/12/2008)

    The execution plans are the same, but the percentages skew slightly. The join query has 235 reads as opposed to 156 for the IN. Unfortunately the dataset...

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

    October 13, 2008 at 8:26 am

    #884169

  • RE: Returning all rows with Split function

    I appreciate your concern about future posts... but more immediately, are you all set with the current post?

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

    October 12, 2008 at 8:56 pm

    #883961

  • RE: Recover deleted records

    Your toast... sorry...

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

    October 12, 2008 at 8:49 pm

    #883959

  • RE: Table Variables and performance

    Peso (10/12/2008)

    Jeff Moden (10/9/2008)

    G Bryant McClellan (10/8/2008)

    Michael,

    Ummm.... both table variables and temp tables start out in memory and "jump" to TempDB when they overcome some point in memory.

    Really?

    I was under...

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

    October 12, 2008 at 8:39 pm

    #883958

  • RE: Functio to get Amount in words.

    Sure... here's one I was "playing" with and never did go back an finish... It stinks because of all the correlated subqueries... probably gonna be terrible for performance.

    DECLARE @SomeNumber VARCHAR(25)

    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)

    October 12, 2008 at 9:32 am

    #883909

  • RE: Moving replicated "servers"

    I would imagine that it would be done the same way as they told me above.

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

    October 12, 2008 at 9:17 am

    #883905

  • RE: Midnight Date Function

    GilaMonster (10/12/2008)

    And, heh... guess I'm still angry at the fact that the DateTime2, Date, and Time won't convert.

    Why? Other than conversions I haven't found a good reason to convert 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)

    October 12, 2008 at 9:15 am

    #883904

  • RE: Where should the DBA Team exist?

    PaulB (10/12/2008)

    Jeff Moden (10/11/2008)Nope... for a decent size company, that's about what I'd expect except it might be missing the "Project Management" layer.

    For some of the small companies I've worked...

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

    October 12, 2008 at 9:14 am

    #883902

  • RE: Primary Key

    PaulB (10/12/2008)

    Jeff Moden (10/11/2008)

    Heh... and by the way... this...

    T - you do whatever transformation or massaging is needed...

    ... sometimes means deleting duplicated data. 😉

    Nope. We do not delete on Staging....

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

    October 12, 2008 at 8:27 am

    #883889

  • RE: trigger question

    GilaMonster (10/11/2008)

    A trigger always runs within the context of the transaction started by the statement that fired it. If you issue a rollback statement within a trigger you will roll...

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

    October 11, 2008 at 10:04 pm

    #883847

  • RE: A different Distinct Query

    johncyriac (10/11/2008)

    ...this particular database is in SQL 2000

    Heh... [font="Arial Black"]SLAP!!![/font]

    Scott's method will absolutely be the fastest. But, just in case you can't do anything to the table or can'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)

    October 11, 2008 at 10:00 pm

    #883846

  • RE: A different Distinct Query

    Chris Harshman (10/11/2008)

    D'oh! this isn't the first time I've given someone a 2005 solution to a 2000 problem, sorry about that.

    Not your fault... this IS a 2005 forum. ...

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

    October 11, 2008 at 9:42 pm

    #883845

Viewing 15 posts - 47,776 through 47,790 (of 59,099 total)