Forum Replies Created

Viewing 15 posts - 5,416 through 5,430 (of 5,678 total)

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (10/1/2010)


    Trey Staker (10/1/2010)


    tshelly (10/1/2010)


    Trey, I think your comments to CELKO might have shut him down... at least temporarily. He was actively bashing folks left and right up until...


    - 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: Performance Tuning

    getoffmyfoot (10/1/2010)


    seems like that would be a good place to start. Maybe calculate that thing once and hold it in a variable, and use the variable in the where clause....


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

    While we're on the subject of sample data, anyone know where I can get 300,000+ records of description data with 400-6000 character average ( no, I didn't lose the zero...


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

    Stefan Krzywicki (10/1/2010)


    Alvin Ramard (10/1/2010)


    Stefan Krzywicki (10/1/2010)


    Alvin Ramard (10/1/2010)


    Stefan Krzywicki (10/1/2010)


    GilaMonster (10/1/2010)


    jcrawf02 (10/1/2010)


    Just realized the solution, I'll have to find a carrier pigeon to tie a flash drive to 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: Open Row Set - Skip First N rows

    thekrauseman (10/1/2010)


    Hello All.

    I am trying to import excel files using the OpenRowSet command, and am having success when the headers are on the first row. Here is the script:

    SELECT *...


    - 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 you see the Recovery Model?

    SwayneBell (10/1/2010)


    Well, I'm not going to theorize with them for too long. I'm just going to cut to the chase and get them to restore to a point-in-time, as 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?

    CirquedeSQLeil (9/30/2010)


    Grant Fritchey (9/30/2010)


    CirquedeSQLeil (9/30/2010)


    WayneS (9/30/2010)


    CirquedeSQLeil (9/30/2010)


    GilaMonster (9/30/2010)


    The problem is what he's mapping out in the project plan is actual elapsed time, not time spent on his project. Since neither...


    - 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 raise alert on table row count

    mickeytech2000 (9/30/2010)


    I am not doing any Inserts. All I need is when the number of rows in a table reaches 50, I want an alert raised and written 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?

    GilaMonster (9/30/2010)


    What's Sanctuary?

    Fun Monsters and Mayhem Sci Fi TV show set in modern day.

    In other news relating to my bitching around project management yesterday ... Spent 4 days doing crit...


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

    jcrawf02 (9/30/2010)


    I'm bored, can we talk about something else?

    New season of Sanctuary looks good...


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

    Steve Jones - Editor (9/30/2010)


    He is trying for some effect. He has built this reputation as the tough, mean, college professor type, and he sticks to it.

    This is not 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: SQL is slow

    Rog Saber (9/30/2010)


    Here's one that is taking a while:

    [Snip beginning of statement]

    and (RT_TRIP_COMMENTS.comment_type <> 'EX' or RT_TRIP_COMMENTS.comment_type is null)

    The <> here is probably blowing up an index seek. Need...


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

    GilaMonster (9/30/2010)


    Craig Farrell (9/30/2010)


    I wonder if this is the trigger I noticed this morning. He's usually tactless, but this morning it's like he's trying to be mean, instead 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?

    GilaMonster (9/30/2010)


    Interestingly enough, over at SQLTeam Joe replied to someone's post with a request for DDL. No insults, no arrogance, just a standard request for table definitions, etc and 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: Help with Update Query

    CELKO (9/30/2010)


    Think I scared him enough he might stop writing danger code? I hope so

    Nope. I do think you've managed to make sure he won't buy your...


    - 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 - 5,416 through 5,430 (of 5,678 total)