Forum Replies Created

Viewing 15 posts - 2,941 through 2,955 (of 5,678 total)

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (6/21/2011)


    If you've never had to deal with connectors, sources, and destinations other that OLE DB, you may never actually use that task, actually. But I don't know many...


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

    The code for this can get pretty complex, so if you can provide consumable sample data like you'll find in the first link of my signature, that'd help us present...


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


    The problem that I'm becoming more and more aware of is that people really don't know how to run procs that contain xp_CmdShell without giving the proverbial keys...


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

    Greg Edwards-268690 (6/21/2011)


    So they haven't even memorized a list of SSIS interview questions and answers.

    Wait, maybe that's a good thing.:-D

    It might lighten up someone's day to share some of 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: stored proc occasionally hangs?

    sqldba_icon (6/20/2011)


    Can someone please help in identifying as to where else should i look. This is so weird query is occasionally hung at a batch but runs perfectly normal through...


    - 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: How to optimize this query

    Going to need more information, such as the execution plans.

    Check out the second link down on the left in my signature, it'll walk you through what we'll need to effectively...


    - 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/20/2011)


    That's one of the points I tried to make in my very first post on this thread.

    A recap for all from post #1: 😉

    As a precursor to 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: Are the posted questions getting worse?

    SQLRNNR (6/20/2011)


    Lynn Pettis (6/20/2011)


    Craig Farrell (6/20/2011)


    Lynn Pettis (6/20/2011)


    Craig,

    Is this a mandatory butts-in-chair position or is it something that could actually be done remotely (even during evening and weekend hours)? ...


    - 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: Query Help

    jared-709193 (6/20/2011)


    I'm sorry, maybe I was not clear... The default collation for SQL Server is not case-sensitive. I believe we are saying the same thing 🙂

    Thanks,

    Jared

    Nope, definately not clear....


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

    Lynn Pettis (6/20/2011)


    Craig,

    Is this a mandatory butts-in-chair position or is it something that could actually be done remotely (even during evening and weekend hours)? There may be qualified applicants...


    - 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: Query Help

    jared-709193 (6/20/2011)


    I want to make note here that collation may not the issue. Collation allows you to filter on case, not insert and return it.

    Incorrect, please test the following...


    - 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 (6/20/2011)


    But Craig, don't you realise that it is normal for all advertised jobs in computing that the majority of applicants come nowhere near the advertised requirement? It's...


    - 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 using Tally Table for updates

    jarid.lawson (6/20/2011)


    The question I'm trying to understand is how to use tally table logic. Not specifically to solve this problem, but if this problem could be solved with it, then...


    - 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: Query Help

    C a z (6/20/2011)


    With only that information you have given me I am gonna put money on the select DISTINCT is the issue - SQL normally works top to bottom...


    - 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: Agile and Database design

    Hm, guess I should just run down these questions.

    Jayanth_Kurup (6/20/2011)


    How do you find designing databases without complete specs ?

    No different, really, then designing WITH specs, except that I can point...


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