Forum Replies Created

Viewing 15 posts - 4,036 through 4,050 (of 5,678 total)

  • RE: To get the Max value from one column with case statement without using any aggregate functions

    EDIT: I was going to respond again but then I realized I was answering the exact same argument for the third time. You ignore half of what I say...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (2/13/2011)


    You are certainly right. I'm afraid I didn't make myself clear with my statement.

    The developer shouldn't be the only one who is testing his code. Unfortunately I've seen...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: To get the Max value from one column with case statement without using any aggregate functions

    nadabadan (2/13/2011)


    Note, our first exchange. No tangents, yet, simply a back and forth regarding the value of the question in our eyes. Now, you've begun to take offence simply because...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: Are the posted questions getting worse?

    Tom.Thomson (2/12/2011)


    Craig Farrell (2/12/2011)


    Oh, I realize your argument, Jeff, and it is what I originally did. However, your statement can go both ways. Do you simply ignore a...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: To get the Max value from one column with case statement without using any aggregate functions

    Publically, then. As you wish.

    nadabadan (2/12/2011)


    I'm more aggravated at the mindless horde who have decided to inject themselves into this thread.

    At my request, actually, since the last time I...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: To get the Max value from one column with case statement without using any aggregate functions

    Nadabadan, since it's me you're aggravated with, perhaps we should discuss it further. PM me if you'd like to do it privately, or simply respond here publically. I'm...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: Are the posted questions getting worse?

    GilaMonster (2/12/2011)


    george sibbald (2/12/2011)


    And why do people post a reply thats almost a verbatim copy of a previous post? Being proved wrong I can just about take (with embarrasement) but...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: Are the posted questions getting worse?

    Jeff Moden (2/12/2011)


    Tom.Thomson (2/12/2011)


    Craig Farrell (2/11/2011)


    Anyone here mind if I cut loose on him? I truly believe he'll be tasty. I wanna eat him.

    My view is that if...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: Are the posted questions getting worse?

    I see, so it's my sarcasm reversed to him that's got him set off. I'm sure he's quite annoyed at this. He's almost ready... just shy of a...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: Are the posted questions getting worse?

    Trey Staker (2/11/2011)


    Anyone going to SQLSat 47 in Phoenix on the 19th?

    I Kin Hav SQL Sater-dayz?! Um, yes, most likely. Didn't even realize there was going to be...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: Are the posted questions getting worse?

    jcrawf02 (2/11/2011)


    The Dixie Flatline (2/11/2011)


    QA is where some developers send their code to see if it works correctly or not. Often they do this without verifying that it...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: What is wrong my script?

    adonetok (2/11/2011)


    You are right.

    After adding "go", it works fine.

    What is happend?

    Does SQL have refresh table command?

    Original, non-modified version of #TMP may have still been in memory. Usually when I...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: What is wrong my script?

    I copied and pasted your script directly into my SSMS 2005... and don't get a failure. No idea why this is breaking.


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: SSIS Package - Data Flow Task

    With both of those flags enabled, you should be able to find the output of the deadlock in the error log.


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • RE: Count of variables with a particular value

    srferson-957148 (2/11/2011)


    Thanks for replying again Craig.

    I do know what persisted and non-persisted mean.

    I don't understand what the advantage to one over the other is.

    Why do you say I'd...


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

Viewing 15 posts - 4,036 through 4,050 (of 5,678 total)