Forum Replies Created

Viewing 15 posts - 1,696 through 1,710 (of 5,678 total)

  • RE: records disappearing after insert, occasionally of course

    Stephanie Giovannini (3/28/2012)


    There are some issues with the VB.NET code.

    I'll leave the .NET code discussion to you, Stephanie. I dabble, if someone more experienced with it has arrived...


    - 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: records disappearing after insert, occasionally of course

    Alright, that is, officially, nasty code. The dynamic column/values list build avoids the possibilities of future schema change, but you haven't dealt, I don't believe, with all possible data...


    - 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: Is Computer Science Dead?

    I'm always surprised by the concern this question raises. Is Computer Science dead? No, of course not. Does everyone who works in IT need it? 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?

    SQLRNNR (3/28/2012)


    Brandie Tarvin (3/28/2012)


    L' Eomot Inversé (3/28/2012)


    GSquared (3/28/2012)


    I can just see it now. We're going to end up with a Reality Show on The Thread: Waiting for 40k

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

    L' Eomot Inversé (3/28/2012)


    GSquared (3/28/2012)


    I can just see it now. We're going to end up with a Reality Show on The Thread: Waiting for 40k

    Do you think the reality...


    - 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: Is Computer Science Dead?

    James Goodwin (3/28/2012)


    The essay and the comments conflate too many things.

    Computer Science is not programming, is not Computer Engineering, is not IT.

    Computer Science is the field of mathematical analysis 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?

    Brandie Tarvin (3/26/2012)


    How would you all like to design the system (and database) around this one: http://www.cnn.com/2012/03/26/opinion/frum-identity-cards/index.html?hpt=hp_bn7

    Sold. Can we start the tech spec tomorrow?


    - 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 (3/26/2012)


    Kiara (3/26/2012)


    Happy Monday, folks!

    Just coming up for air after a couple of weeks of crazy. Figured I'd catch up on The Thread and say "Hi".

    Hi, back. Welcome 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: Are the posted questions getting worse?

    Lynn Pettis (3/26/2012)


    bitbucket-25253 (3/26/2012)


    Lynn Pettis (3/26/2012)


    You do know that under the Social Security Act that Social Security Numbers are not supposed to be used as a form of identification?

    Enforcement 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: Gaining experience with no experience?

    If you don't mind a little self-promotion, an article I wrote for SSC on this topic:

    http://www.sqlservercentral.com/articles/Career/71608/

    Edit: Whoops, wrong one.

    http://www.sqlservercentral.com/articles/Career/73400/


    - 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 (3/23/2012)


    SQLRNNR (3/23/2012)


    GilaMonster (3/23/2012)


    Lynn Pettis (3/23/2012)


    Wants a primary key on fname and lname.

    You say that like it should be obvious it's a bad idea. I got so much flak 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: truncation size problem in ssis

    Daniel Bowlin (3/23/2012)


    You add a derived column transformation to your data flow. Using the column where the data is too long create a new column with a meaningful name...


    - 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

    Use a cte to apply a NEWID() to each row, and use a Row_Number() OVER (ORDER BY NULL) to apply a rowNumber to each row.

    Now, apply a groupNumber by taking...


    - 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: truncation size problem in ssis

    Use a derived column and grab the left of the field.

    Anything that can have over 255 characters in Excel tries to come in as memo/Varchar(Max). If you want 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: C# vs VB

    I have to admit I agree about the case sensitivity routine, but not for the reasons most people do. I don't care about having to type properly, that's not...


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