Forum Replies Created

Viewing 15 posts - 4,051 through 4,065 (of 5,678 total)

  • RE: Are the posted questions getting worse?

    GilaMonster (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.

    Oh, you mean production. Cool, now I'm clear... :sick:

    Hm, 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: Are the posted questions getting worse?

    Brandie Tarvin (2/11/2011)


    I don't think he's deliberately being a troll. I think he's just being himself.

    I'm hoping my last post makes him think about the way he's presenting himself.

    Godbless and...


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

    Brandie Tarvin (2/11/2011)


    Craig Farrell (2/11/2011)


    Anyone else who's seen Full Metal Alchemist, I'm starting to feel like Gluttony. "Can I eat him now?"

    But he's special. He has to be kept...


    - 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

    The result of persisted is stored with the table, as though it was a column, and is recomputed anytime the record is updated. Non-persisted is re-computed everytime the column...


    - 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: Published Again!

    Out of curiousity, I tried googling the book "A career guide to your job from hell".

    Out of amusement, I got to see google show me the last 20 posts from...


    - 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: Most Work is Mundane

    Paraphrased from my most recent interview for my current contract:

    Interviewer: "Most of this work is going to be boring, simple work."

    Me: "Thanks for the warning, but I'm okay with that....


    - 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: No Lock

    carlo 47463 (2/10/2011)


    Then surely there is no chance of dirty data,phantom rows etc? The 2 applications do not select based on the same AppKey and there will also only 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: SSIS Package - Data Flow Task

    These are the important ones:

    OnError,CRM,CRM\Administrator,Data Flow Task,{25953080-4815-49F6-B918-1DF2D76F34A9},{AE9C75BA-F1C0-46E3-9BE6-BE14E2606778},10/02/2011 16:48:22,10/02/2011 16:48:22,-1071636471,0x,SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.

    An OLE DB record is available. Source: "Microsoft SQL Native...


    - 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: Trigger or Not Trigger

    CELKO (2/10/2011)


    Triggers are a bad idea for audits and in some cases they are illegal.

    :blink: News to me. Could you give some examples of that?


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

    Anyone else who's seen Full Metal Alchemist, I'm starting to feel like Gluttony. "Can I eat him now?"

    On another note, it's 2 in the morning and I'm still watching...


    - 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: Need help with sql query

    LutzM (2/10/2011)


    @craig-2: Two things I would change: First, the data type (VARCHAR(20) is not really appropriate in this case) and second the order of month, day and year (add 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: Count of variables with a particular value

    sr,

    While the trick above can perform some tasks, I don't think that's what you're looking for. These variables (I assume they're columns?) are per record, right?

    So what you want...


    - 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: Need help with sql query

    Yeah, I was afraid of that. You'll have to do something like this short term:

    ;with cte AS

    ( SELECT *, CONVERT( DATETIMe, CONVERT( VARCHAR(20), salesmonth) + '/' + CONVERT(...


    - 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

    nzngh (2/10/2011)


    I can't see why are you attempting to close the discussion out of only one person crossing over. It could be solved by simply hinted him/her to not to...


    - 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: Need help with sql query

    You'll have to post the DDL and sample data (see first link in my sig for help if needed to make it consumable) for us to help you on this....


    - 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,051 through 4,065 (of 5,678 total)