Forum Replies Created

Viewing 15 posts - 991 through 1,005 (of 5,678 total)

  • RE: Isolation level using linked server

    I'm not sure we can help you with this. Openedge seems like a proprietary driver, and Progress appears to be a Teradata solution. The problem sounds like it's...


    - 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: Linked Server Time - out

    Network timeouts will look the same way a query timeout will. There's also server level timeout settings, the linked server timeout will merely override it.

    Rt-Click your server, then go...


    - 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: View image stored in VARBINARY(MAX) column in SQL SERVER 2008

    Anon, Holidays ate me for a while, apologies. Did you still need help with this? How did the files get loaded to this in the first place?


    - 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: View image stored in VARBINARY(MAX) column in SQL SERVER 2008

    Inside of SQL Server? You don't, it doesn't render binaries to native format for you.

    You'll need to extract it again back to its native format and then use other...


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

    Oh... EAV model... HOW I HATE YOU...

    We're currently upgrading between versions on a piece of vendor software. Short version is they allow for end users to create custom fields....


    - 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: What would be the best RAID configuration for this hardware?

    There's a lot to consider when you're debating on spindle splits... but I wouldn't worry as much about RAID 5 vs. 10 for read/write anymore. All the newer "Big...


    - 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 derived column better for performance of a package ?

    Randy Knight (11/12/2012)


    rhythm.varshney (11/12/2012)


    yes.I am importing the data to staging table as it is and there I am applying split on a column say name into first name and last...


    - 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: Trying to pull from many tables with similar names using one for each loop container

    mmartin1 (11/1/2012)


    I'd like to copy these tables nightly to another database using SSIS. Since the amount of tables can increase I am wondering if there is a way to do...


    - 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: Iterate through a table valued parameter

    What you're looking for is CURSOR or WHILE for loops in T-SQL.

    That said, they're the worst way to approach this problem.

    What you really want to do is look at 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: Configuration Management Strategies a Database

    Yes, they're basically thinking of versioned deployments. This is achievable but will require you to approach design slightly differently.

    My personal preference is feature based rollout/rollback scripts. For each...


    - 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: Production DBA Vs Project/Development DBA

    A bit of a self promotion, but please let me know if this article helps:

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


    - 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: Simple SSIS package cancels and stops

    My initial guess is that it sounds like you're not getting the entire error from the ADO source. Try connecting to it via a script externally with the same...


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

    Happy birthday to thread, Haaapppy birthday to thread...

    It's a shame we can't retitle this monstrousity.


    - 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 a "simple" XML example, please

    Jeff Moden (11/9/2012)


    Thanks for the help.

    I looked up what the 3rd operand stands for in OPENXML and it appears to control whether you're using element or attribute based XML. ...


    - 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: Pivot on Month when Missing Months

    I don't see anywhere in your query where you're actually doing division. Is this a short version of the code or is it end to end?


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