Forum Replies Created

Viewing 15 posts - 54,646 through 54,660 (of 59,072 total)

  • RE: How can I make this faster?

    You've managed, quite nicely, to build a partially exclusive Cartesian Join known as a "double triangle" join. Please see the following post...

    http://www.sqlservercentral.com/Forums/Topic359124-338-1.aspx#bm360151

    You need some other criteria, hopefully and equi-join,...

    --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, 2007 at 7:29 pm

    #741421

  • RE: Filling in numbers

    Hi Greg,

    I don't know if Belution is kaput or not... I've seen them go down for several weeks only to rise again. Looks pretty bad this time, though... haven't seen...

    --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, 2007 at 6:09 pm

    #741411

  • RE: The USE command

    Well sure it does, Ken... how else are you going to "step through the databases"? sp_ForEachDB??? That's got dynamic SQL and cursors, too!

    --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, 2007 at 6:16 am

    #741151

  • RE: Remove Decimals Without Rounding

    Heh... yeah... several solutions similar to that were posted.

    The remaining question I have is, what will this be used for? Without knowing were the decimal point WAS... the information...

    --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, 2007 at 6:02 am

    #741145

  • RE: The USE command

    ... and that was my point... not all Dynamic SQL is bad nor even indesireable.

    --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, 2007 at 5:56 am

    #741142

  • RE: Update Order and MAXDOP

    So far, nobody can explains to me that my original query with INNER JOIN doen't works and without INNER JOIN, works very nice.

    ... and you haven't posted the real life...

    --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 10, 2007 at 5:21 pm

    #741023

  • RE: Update Order and MAXDOP

    Please provide the code and data that demonstrates when the correctly specified Update and Index fails. Then provide your correct Order By method that solves the 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)

    October 10, 2007 at 7:18 am

    #740784

  • RE: is this a good view?!

    The code you have is the classic code necessary to put records together from multiple rows in a name/value table. It's actually pretty darned fast... only thing faster would...

    --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 10, 2007 at 6:41 am

    #740748

  • RE: Sql Problem

    Sarvesh,

    First... when you get an error, you need to post it so we can see what's going on.

    Second... are you actually using SQL Server 2005?

    --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 10, 2007 at 6:29 am

    #740730

  • RE: Dynamic query issue

    Saritha... it would be really nice if you shared how you solved 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)

    October 9, 2007 at 10:50 pm

    #740635

  • RE: How to tell which is better?

    No... if you're talking about simple duration measurements, it's not useless... you've just gotta make sure they're either both "hot" or both "cold" 😛

    But, in the face of blocking, looking...

    --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 9, 2007 at 10:30 pm

    #740629

  • RE: SQL Query tuning

    Heh... Thanks, Noel... I keep forgetting to check the date on the original post...

    Oh well... keeps my hand at typing and I have seen it where the OP actually...

    --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 9, 2007 at 10:28 pm

    #740627

  • RE: Update Order and MAXDOP

    The update method works well, in all cases... and it does NOT depend on a Clustered Index... just SOME index.

    You just need to settle down, maybe have a beer, and...

    --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 9, 2007 at 10:22 pm

    #740626

  • RE: Median Calculations

    Hey folks... I had reason to revisit this post to demo to someone else... I don't know what change was recently made to the 2k server I work on but...

    --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 9, 2007 at 9:46 pm

    #740615

  • RE: datapump is verrrrry slow

    Linda Robinson (10/9/2007)

    Jeff, I agree there should be a better way, but since the people who own the application like their datapump (I've talked to their tech support), I'm stuck...

    --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 9, 2007 at 5:57 pm

    #740599

Viewing 15 posts - 54,646 through 54,660 (of 59,072 total)