Forum Replies Created

Viewing 15 posts - 2,806 through 2,820 (of 5,678 total)

  • RE: Convert to bigint

    PHXHoward (7/8/2011)


    Does that make sense? I don't like the replace method because it is altering the data. Can SQL Server handle a value like 0x180?

    The question makes sense, and you're...


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


    GilaMonster (7/8/2011)


    Craig Farrell (7/8/2011)Saturday's article: Why some DBAs are Nincompoops. Sunday's article: Retraction of previous article with editing: Why ALL DBAs are Nincompoops.

    Monday's article: Why some...


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

    mtillman-921105 (7/8/2011)


    Speaking of old, it's time to change my avatar. Carl Fredrickson was looking too, um, classic.

    Not a bad idea, time to go back to a classic. 🙂


    - 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 Urgent Report : Script to prevent SSIS package from running on multiple servers

    A little more detail.

    You want this package to not run on any server but one particular one?


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


    Craig Farrell (7/8/2011)Saturday's article: Why some DBAs are Nincompoops. Sunday's article: Retraction of previous article with editing: Why ALL DBAs are Nincompoops.

    Monday's article: Why some clients 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?

    Steve Jones - SSC Editor (7/8/2011)


    SQLRNNR (7/8/2011)


    SQLkiwi (7/8/2011)


    Steve Jones - SSC Editor (7/8/2011)


    Behave.

    Badly?

    Think much much worse than that 😀

    Umm, should I disable a few accounts today?

    Disable? nononono...

    EMPOWER!

    Saturday's article: Why...


    - 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: Point in time recovery using full backup (Backword recovery)

    siva_krishnan (7/7/2011)


    3. We have a full database backup as at 30th june 2011. (1 month data)

    4. No transaction log backup at all since day one.

    5. Now user need the 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: No error for missing Linked Server?

    Found problem.

    Please note: If you're not familiar with how to properly escape unexpected errors out of your Try/Catch, please learn before using it in production code and driving some poor...


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

    Hey guys, I could use a hand here: http://www.sqlservercentral.com/Forums/Topic1138580-338-1.aspx

    My google-fu is failing, my brain is on vaporlock at my confusion, and I've placed a nice bullseye on my desk...


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

    Jim Murphy (7/7/2011)


    GSquared (7/7/2011)


    Yeah, the indexing on The Thread is definitely broken. It's all "bookmark lookups" and "out of date stats" and the fragmentation on the "subject under discussion"...


    - 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: Service Broker queue insert vs. table insert

    Don't use Service Broker as an optimization tool. It's there for concurrency load and multi-server asynchronous transfers. You will never get better performance from the broker on 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: SSIS For Each loop

    Gyeah... yeah, I know how, you won't like it though.

    Use a script task to build a component list for the ForEach loop using VBA for Excel, then for each 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: Modify and saving SSIS package

    sql_novice_2007 (7/6/2011)


    I changed one of the ssis package by opening it from file location and saved it by just clicking save button in visual studio and then importing it 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: DateTime or nvarchar

    Bruce W Cassidy (7/6/2011)


    Good advice, Craig. I hadn't thought about it from that point of view.

    You get used to hearing the arguments when the database is being used as...


    - 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: Rookie DBA

    I'm not sure if this will help you any, but it's an article I wrote recently for here. Sorry for the self-plug, but it pretty much was written for...


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