Forum Replies Created

Viewing 15 posts - 4,951 through 4,965 (of 5,678 total)

  • RE: Burned Out?

    There's a few burnouts, I think I've ran into all of them. (No, these aren't in your psych 101 class, either, just my take on 'em).

    The worst for me is...


    - 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: Really? Then how? (Rant/Vent)

    David Lester (11/15/2010)


    Ha! Ha!

    Consultant, 'You know, you could stop out at a PC store, pick up a cheap laptop and run better than this server does'

    I couldn't resist......


    - 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: CHARINDEX in WHERE clause?

    r.vanlaake-1086273 (11/15/2010)


    I was having a discussing with a collegue. I believe it is not wise to put a CHARINDEX in a WHERE clause because of degrading performance. He believes 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: After indexing subquery gives wrong result

    Hey,

    Couple of questions.

    This requirement for 'UPPER' implies case sensitivity on your server:

    and UPPER(isnull(b.Completed,'No'))='NO'

    so, since the 'only' thing that changed was your re-indexing, did you modify case sensitivity as well...


    - 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: TSQL Best Functionalities needed

    srinadh.ramineni (11/12/2010)


    Hi for the below questions i need good and efficient answers.

    Sorry, can't really help you there. What you need is the proper topic to research. 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

  • RE: Week Part

    Michael Valentine Jones (11/12/2010)


    You might find it easier to understand it this way to overcome the confusion of -7 -1 and to just see it done with dates:

    First, find the...


    - 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 helping my daughter with math

    Lynn Pettis (11/12/2010)


    John wants to make a 10 fl oz 3% acid solution by mixing together a 10% acid solution and pure water.

    10% acid is 10% of the acid suspended...


    - 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: "Best Practice" concerning SQL .mdf and .ldf files & SAN.

    Craig Farrell (11/12/2010)


    SAN engineers tend to not want to do a proper SQL Setup, and I don't do their jobs well enough to understand why they're usually against it besides...


    - 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: Dynamic Directory specification in Foreach File Enumerator

    It's there, just got to be on the right tab. There's two sets of expressions to build in that object. One controls external properties, the other internal properties....


    - 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: Log Backups don't keep up during weekend maintenance

    Indianrock (11/12/2010)


    The only things I can think of are to expand the log drive and/or flip to simple recovery during the maintenance..

    One problem with the simple...


    - 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: error while scheduling the ssis package.

    If you click on the background of the package and go to options, you'll find under 'Security' an item called 'Protection Level'.

    This is how you set the SSIS to store...


    - 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: "Best Practice" concerning SQL .mdf and .ldf files & SAN.

    michaelkinlb (11/12/2010)


    Does using a SAN for SQL Server data and log files invalidate the "Best Practice" of having .mdf and .ldf files on separate storage arrays? I would be interested...


    - 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: error while scheduling the ssis package.

    Need to have it store the SQL password, which means you'll need to use one of the save security information options, using a package password and the like.

    The other option...


    - 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: Week Part

    Jeff Moden (11/11/2010)


    Perhaps the following code will make it easier to explain what was going through my head when I wrote the forumula. A couple of big hints here...


    - 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: Different results running SQL as sp vs. adhoc

    Haven't seen that before, dfalso, except when I'm getting different defaults off my procedure declaration.

    I know you're trying to keep the code to a reasonable length here, but this is...


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