Forum Replies Created

Viewing 15 posts - 2,956 through 2,970 (of 3,348 total)

  • RE: UPDATE() and triggers

    Sjimmo and Steve,

    It's like you say, but then it goes even a step further.

    The UPDATE() function does, as you indicate, not check if any values actually changed.

    But it also doe...

  • RE: UPDATE() and triggers

    anil.kubireddi (12/2/2009)


    i am refferning to the below question posted,

    What is the output of the following code (disregarding "X row(s) affected"):

    CREATE TABLE TriggerTest (Value int)

    GO

    INSERT INTO TriggerTest VALUES (1)

    GO

    CREATE TRIGGER tr_TriggerTest...

  • RE: Rules!

    bitbucket-25253 (11/19/2009)


    Having recently gotten my brains beat out, my integrity questioned, my intelligence derided and other wise vilified (Refer to the QOD 11/17/2009 forum). I am greatly surprised...

  • RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

    Well, I've allowed myself to be distracted into a discussion on what can be deducted from particular operators in the execution plan and whether or not the quirky update can...

  • RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

    Jeff Moden (11/10/2009)


    You have to observe all the rules at once, Hugo. I said in the rules that you can't use a JOIN in conjunction with the "Quirky Update"...

  • RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

    Jeff Moden (11/10/2009)


    Hugo Kornelis (11/10/2009)


    ... and shaved off another half a mintue - 3:58.

    Heh... very cool optimization of the cursor, Hugo. You've managed to upgrade it to only...

  • RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

    Hi again!

    I've now finished the article, and I just want to post two more comments before I start trying to adapt my set-based iteration method for this specific problem.

    First: In...

  • RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

    Hi Jeff,

    Still reading the article. Slowly, though, as I had to do the shopping - cooking - eating - taking kids to bed routine in between. But here are two...

  • RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

    Thanks Jeff.

    I also found a TEMPDB (fully upper case) and a Master when I ran the code to create the million row table. If you have a chance, you might...

  • RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

    Hi Jeff,

    Thanks for doing a rewrite of this article.

    Just a few comments before I start really reading the article:

    1) Being one of the people who tried to grill you over...

  • RE: ISNULL

    Carlo Romagnano (11/3/2009)


    Noel McKinney (11/3/2009)


    This is the main reason I make it a habit to use COALESCE rather than ISNULL unless there's a reason I need the behavior of ISNULL.

    I...

  • RE: Varchar or Char?

    hawaiianrebel (10/16/2009)


    See I got it wrong for two reasons:

    I was a knuckle head and missed the "English only" so yes varchar or char. The choice between the ...

  • RE: Varchar or Char?

    Toreador (10/16/2009)


    The question asks which is more efficient.

    The explanation describes which uses least space, which is not the same thing as most efficient.

    I suspect that the answer is correct, but...

  • RE: Varchar or Char?

    hakan.winther (10/16/2009)


    Hugo Kornelis (10/16/2009)


    That's reallly a shame, as the only good reasons to use varchar instead of char are a difference of more than 2 between average and maximum length;...

  • RE: Varchar or Char?

    Damian Widera-396333 (10/16/2009)


    in terms of I/O we could assume fixed length data types are better than varying ones.

    If, and only if,

    a) the average length of data is only 2 characters...

Viewing 15 posts - 2,956 through 2,970 (of 3,348 total)