Forum Replies Created

Viewing 15 posts - 886 through 900 (of 5,678 total)

  • RE: Table Variable Parameters - Odd design choices or am I just not finding the answer

    On a side note... the XML datatype will not allow itself to be passed as a parameter between linked servers.

    Seriously.

    You have to pass a VARCHAR(MAX) then shove it into 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: How's this for a Job Description

    Scott D. Jacobson (1/8/2013)


    hisakimatama's latest post is beyond frightening. This is like saying "I need you to be a DBA but also drive a tractor trailer". There has to 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: Question about Optional Parameters in Stored Procedures

    Jacob,

    What you're doing is basically preparing the beginning of a catch-all query, of which there are two approaches. There's the easy to maintain version, which is what you're doing....


    - 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's this for a Job Description

    GSquared (1/8/2013)


    Grant Fritchey (1/8/2013)


    hisakimatama (1/8/2013)


    No kidding. I saw the SQL-related bits and figured the salary was acceptable enough, then I caught the rest of it... Ack. Amusingly,...


    - 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: Table Variable Parameters - Odd design choices or am I just not finding the answer

    I think we're finally drilling down to my confusion, Orlando, so thanks for the help. There's assumptions I was making about the connection object that are obviously inaccurate. ...


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

    Star Wars: A universe where space is an atmosphere and your cells are psychic.

    Star Trek: A universe where fuses are considered overkill and bathrooms are optional.

    Babylon 5: Where every sentient...


    - 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: Table Variable Parameters - Odd design choices or am I just not finding the answer

    opc.three (1/5/2013)


    Not sure I am completely getting the concern, but I thought I would trace a stored proc call from .NET and show what SQL the SqlClient actually generates on...


    - 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 SSIS package

    pjrpjr7 (1/4/2013)


    Thanks, Phil. I did that already, It gives me an error 'The configuration file name .... is not valid. Check the configuration file name.

    SSIS menu, Package Configurations... something 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: A SSIS Question

    opc.three (1/4/2013)


    The way I am viewing it is that SSIS will try to use a file regardless of whether it can gain exclusive access to it or not. That is...


    - 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: A SSIS Question

    opc.three (1/4/2013)


    Evil Kraig F (1/3/2013)


    Agreed. I was not saying the code you showed doesn't have a place, only that it is more prone to having a problem than code that...


    - 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 up to speed on their table value parameters in 2k8? I could use some clarity on the subject if you'd be willing to help. Here's the thread:...


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

    Thanks for the recommendations. 🙂


    - 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: A SSIS Question

    opc.three (1/3/2013)


    Be careful implementing code like this. You are not checking for exclusive access to the file before allowing the SSIS package to proceed in processing it. If someone were...


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

    Any twitter folks here use a samsung galaxy? If so, what app do you recommend?


    - 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 run ssis package on table update

    mpradeep23 (1/2/2013)


    i have two database

    one is main

    other is dev

    in the main i have a two tables called users and userinformation

    i need only few columns from users and userinforamtion...


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