Forum Replies Created

Viewing 15 posts - 121 through 135 (of 5,678 total)

  • RE: db owner

    sqlfriends (8/12/2014)


    Is CodeSmith one of them?

    Thanks

    Yes. An older topic on the discussion:

    http://www.sqlservercentral.com/Forums/Topic1375474-391-1.aspx

    It's short, but the following google search should also lead you in the right direction for looking over...


    - 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: db owner

    sqlfriends (8/12/2014)


    Does that mean all the read and write should go through stored procedures?

    for example even select from a table need to write a procedure to achieve?

    I think this 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: Career future , stay or switch

    A quick note about the S-Corp/1099 option that Alan recommends above. If you don't 1099 through another company that carries $1m insurance, at least in America, expect to only...


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

    More than a few reasons why the top of the hills were considered the best real estate way back when. I'm glad to hear everyone so far caught 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: creating a SQL View with calculations

    Not in T-SQL. What you're trying to do is inherit the alias, which doesn't work that way. What you want to do is put your first calculations into...


    - 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: Forcing ordered execution in SSIS

    That thread is about someone who misplaced a control between sequence containers. It visually looked like it was in a different container than it actually was. That'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: Forcing ordered execution in SSIS

    ipisors (8/11/2014)


    Just the fact that I have precedence constraints for "success AND [variable]", yet if the 2nd box has errors, those errors end up getting raised.

    Why, if they...


    - 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 select union all using multiple databases

    I would disagree. I think the better approach would be the OP's original idea, but slightly modified. If you use SELECT * FROM OPENQUERY( LinkedServer, 'sqlstatement'), you'll have...


    - 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: Forcing ordered execution in SSIS

    ipisors (8/11/2014)


    SSIS does not guarantee you that those arrows really mean they are all completing in order and the next one not completing until the previous one has completed. ...


    - 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: Forcing ordered execution in SSIS

    Sorry, but bear with me a second. This may be a newbie needs training question or I'm completely lost as to the issue.

    When you drag the green arrows 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: Werid error in SSIS package executing proc

    SQLTougherGuy (8/11/2014)


    Thanks Phil - So what is the standard? Craigs code seemed to work.

    I'd recommend going with the new style in 2012+. I haven't had the chance to move...


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

    Holy crap, I'm almost speechless:

    http://www.sqlservercentral.com/Forums/Topic1601764-1633-1.aspx


    - 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 can I hide a picture's watermark in Reporting Services? Can I a second image? Please, help!!

    I'm sorry, but are you serious? You want us to help you:

    A) Remove the original owner's watermarks, thus hiding proper copyrighting.

    B) Help you figure out how to alter multiple...


    - 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: Extracting Numerical values from a survey response

    There's really no way out of this. You have a GIGO issue.

    You're going to have to build data strippers. First, fix the front end before this continues 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?

    GilaMonster (8/11/2014)


    Maybe a throttle on posting new threads. [snip]

    This makes sense. Realistically, I can't see anyone trying to make a new thread within 10 minutes of the 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

Viewing 15 posts - 121 through 135 (of 5,678 total)