Forum Replies Created

Viewing 15 posts - 2,911 through 2,925 (of 5,678 total)

  • RE: Reverse arguments in an IN statement?

    drew.allen (6/23/2011)


    Actually what you are looking for is IN itself. There's nothing that requires the left side to be a field and nothing that prevents the right side 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: Are the posted questions getting worse?

    Brandie Tarvin (6/23/2011)


    Are any of you people going to be a GenCon, pretending to be geeky gamers?

    I'm going to be running some Shadowrun events for Catalyst as well as signing...


    - 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: Insert data continuoulsy which generates huge log

    Even with 5000 users IIS isn't going to open up that many connections, and that's usually where you'll see a high user volume, is via a web-app.

    My recommendation to you...


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

    SQLRNNR (6/23/2011)


    Stefan Krzywicki (6/23/2011)


    Jayanth_Kurup (6/23/2011)


    Damn , I knew I should have read thru the previous 2757 pages 😀

    Page 1384 is gold!

    Is that the default 10 posts/page?

    Must be, I'm only at...


    - 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: Does anyone have a good reason to run xp_CmdShell?

    opc.three (6/23/2011)


    OK, that was not what I was thinking of. I now have something to go read up on, thanks 🙂

    I won't let the cat completely out of the bag,...


    - 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: Blob field Help (SSIS)

    rocky_498 (6/22/2011)


    If i hit this link in access table they open new word file with whole description as a text.

    My question is how i can convert this link 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: Does anyone have a good reason to run xp_CmdShell?

    Jeff Moden (6/23/2011)


    Yes, you can run xp_CmdShell procs through the Agent (and that's NOT one of the two methods I'm planning on demoing in the article). But there's 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?

    GSquared (6/22/2011)


    Craig Farrell (6/22/2011)


    GSquared (6/22/2011)


    Driving this in reverse is what comes to mind here.

    So, Bob, What the hell? That's all you got on here? I thought you were...


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

    GSquared (6/22/2011)


    Driving this in reverse is what comes to mind here.

    So, Bob, What the hell? That's all you got on here? I thought you were a professional.


    - 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: SQL names for Twitter

    Rich Yarger (6/22/2011)


    P.S. Be nice!

    Well, that spoiled all my fun... 😉


    - 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: Does anyone have a good reason to run xp_CmdShell?

    Craig Farrell (6/22/2011)


    Where DID I leave Sommerskog's blog links in this silly favorite's folder of mine....

    Oh Lord, Jeff. I haven't fully wrapped my head about it but you're going...


    - 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: Dup values preventing me from creating a UNIQUE INDEX OR CONSTRAINT

    If the opportunity presents itself to upgrade to 2k8, you could do a filtered index that would let you do this only with newer data if you have an incrementing...


    - 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: Does anyone have a good reason to run xp_CmdShell?

    rmechaber (6/22/2011)


    Craig, I looked at BOL for this following your suggestions, and I have a question:

    Looks like you must create a Windows account, grant it NTFS permissions 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: Help Required Pleased: I don't even know how to pharase the question to search for an answer myself :-(...

    BCLynch (6/21/2011)


    Craig, excellent stuff - thanks a lot for taking the time. You're a cool guy.

    Cheers

    B

    Thanks. :blush: Glad to help. Let me know if anything in...


    - 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: Does anyone have a good reason to run xp_CmdShell?

    Jeff Moden (6/21/2011)


    Craig Farrell (6/21/2011)


    Don't look to me to have insider information. I'm blindly stumbling along in the wake of this thread, being the voice of the average soul...


    - 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 - 2,911 through 2,925 (of 5,678 total)