Forum Replies Created

Viewing 15 posts - 1,306 through 1,320 (of 5,678 total)

  • RE: Are the posted questions getting worse?

    Sean Lange (8/9/2012)


    Woohoo!!! Vacation starts in about 7 minutes. Meeting my wife's parents, her brother and another close family friend for a long weekend in Chicago. 16 people in all....


    - 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 the optimizer handle joining views to views?

    In theory, non-indexed views are supposed to be broken down into their component pieces and eventually reassembled as a huge nested query.

    In reality, those huge nested queries, even when directly...


    - 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: Confused about how to design a new process (third week into new role)

    Lynn Pettis (8/8/2012)


    I can relate but in a different way. One of the bloodest projects I had was automating an invoicing process at a former employer. 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: get date part from a filename string

    In addition to the above question, completely variable names could end up with something like this:

    ABC_20120605_Rewrite_20120701_abcd.def

    Which date gets used in something like that, or are you guaranteed to only have...


    - 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 with Query

    littlelisa1111 (8/8/2012)


    My query is displaying the tickets that were created after 2012-06-29.

    Yep, this'll do that if it's closed and the closed date is after 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: Confused about how to design a new process (third week into new role)

    Abu Dina (8/8/2012)


    You're spot on once again. I had a meeting with the Director of Software development and she made a point about the data services team being afraid of...


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

    -- Ignore this, bad joke that's not going to work as planned... I'm not going to get it wordy enough without copy/pasting a phone book or something...


    - 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 read data in a pdf file in SSIS

    sql server developer (8/8/2012)


    Also, if you don't mind can you help me understand what OCR is?

    Optical Character Recognition. Basically: Your scanner takes the blobs on the page and attempts...


    - 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 can I attract Senior Database Administrator candidates?

    bsclyde,

    I'm preparing a response to this but I've been a bit overwhelmed at work lately so I haven't had the time to sit with it until this morning. 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?

    Since we haven't heard from Steve, and I agree it may just be for the politics, the owner of the pic may just not have wanted a forum insta-display img...


    - 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: Security - Owned Schemas

    SQLSACT (8/7/2012)


    Hi All

    I'm trying to understand something regarding SQL Server security

    If I have a SQL Login and that Login is also a user on a database. What happens when 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: Confused about how to design a new process (third week into new role)

    It sounds, personally, like there's actually two primary stages to this process. Standard and Custom. Right now they're rolled into one.

    What I would recommend you do is create...


    - 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: Partitioned Table performance Question.

    Jason-299789 (8/6/2012)


    1) Is the SysId in the PK on the #lookup table pointless? As the col1Id is Unique by default so it doesnt need the additional column to make 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: Are the posted questions getting worse?

    Lynn Pettis (8/6/2012)


    Why do people get upset when you can't provide an answer based on vague requirements?

    Primarily because that's how they get them from business users and hope we brought...


    - 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: Buffer Cache Hit Ratio is Zero and PLE is High

    Were you having network issues or similar problems at the time? You won't get a cache hit rate if there's no activity as far as I remember, but page...


    - 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 - 1,306 through 1,320 (of 5,678 total)