Forum Replies Created

Viewing 15 posts - 2,656 through 2,670 (of 5,678 total)

  • RE: Finding it impossible to Split a column based on a delimiter

    Jeff Moden (8/18/2011)


    I would just pork chop the provider of the spreadsheet and get them to do things right. 😉

    The problem here isn't the providers, it's Excel. Once...


    - 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: If you could use xp_CmdShell securely, would you?

    Jeff Moden (8/18/2011)


    Evil Kraig F (8/18/2011)


    Not exactly... but..... you need xp_cmdshell to trigger independent dtexec's... :hehe:

    I have just three words for that very ironic statement...

    BWAAAAA-HAAAA-HAAAAAAAAAAAAAA! 😀

    I thought you'd...


    - 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: Using output parameters with OLE DB Source in Data Flow Task - SSIS 2008

    opc.three (6/7/2011)


    This thread basically explains what I was thinking you would have to do but I would call it a workaround if anything...not really an elegant solution by any means.

    http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/d85668b6-2981-4b1c-978d-227483d03bae/%5B/url%5D

    Bit...


    - 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: If you could use xp_CmdShell securely, would you?

    Jeff Moden (8/18/2011)


    @Gus,

    Dang... I knew there was something else I wanted to ask and forgot it for a moment. If it's not obvious that I'm no SSIS-Ninja, let me...


    - 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: Finding it impossible to Split a column based on a delimiter

    ashok.theagarajan (8/18/2011)


    Hi Everyone

    I have an input column in an Excel Source, which is of type DT_NTEXT. Inside the data, there is a delimiter text which says "<Break Here>".

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

    SQLRNNR (8/18/2011)


    Roy Ernest (8/18/2011)


    Thx Stephan, Gus and Jason for the input.

    Thread needs only 865 posts to hit 30K and I need 80 posts to hit 3K. Who will reach...


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

    Roy Ernest (8/18/2011)


    I would love everyones opinion on this topic please.

    I see it as the first step needed for ORM and RDBMS to start liking each other again.


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


    Evil Kraig F (8/17/2011)


    jcrawf02 (8/17/2011)


    ALZDBA (8/17/2011)


    Evil Kraig F (8/17/2011)


    Anyone interested in helping someone out architecting a nasty little schema design in Access, can you give this fellow a hand...


    - 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: Database design questions

    goodguy (8/17/2011)


    @craig-2: Having looked at the joys and pains of recursive tables and self-joins, and considering that I know my db has exactly 8 nodes, I feel I would be...


    - 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: Search & pattern matching within text/html values

    SJanki (8/17/2011)


    Hi Kraig F,

    I have the binary images of PDFs in a table stored in varbinary(max). I am using Full Text Search. When I search for 44 f(2)(E), it returns...


    - 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: Search & pattern matching within text/html values

    kazim.raza (8/17/2011)


    Thank you for the reply, double storing might be the last resort, an ultimate dead end.

    Anything searched would have to be a partial word search, which means cat...


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


    ALZDBA (8/17/2011)


    Evil Kraig F (8/17/2011)


    Anyone interested in helping someone out architecting a nasty little schema design in Access, can you give this fellow a hand here: http://www.sqlservercentral.com/Forums/Topic1160273-373-1.aspx

    Seems like a...


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

    Anyone interested in helping someone out architecting a nasty little schema design in Access, can you give this fellow a hand here: http://www.sqlservercentral.com/Forums/Topic1160273-373-1.aspx

    Seems like a nice enough fellow, but what...


    - 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: Auto-update Record Based on Today's Date and Future Date?

    tonyppham (8/16/2011)


    What if when Access 2007 is opened, my startup macro executes the passthrough query instead of performing the waits and checking the time? This will, however, execute the passthrough...


    - 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 Implement DML Queue – A queue that stores DML Commands and executes them asynchronously

    YSLGuru (8/16/2011)


    Evil Kraig F (8/16/2011)


    Let me break that down to what I think I understood. I'm going for the simplest format:

    1) Find all accounts with a transaction on a...


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