Forum Replies Created

Viewing 15 posts - 61 through 75 (of 5,678 total)

  • RE: Managers: who needs them?

    Matt Miller (#4) (10/26/2014)


    Managers should and can be a HELP not a hindrance: mine routinely plays the role of "left tackle" to keep my way clear to get...


    - 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: CI and CD Aren't Magic

    Doctor Who 2 (10/27/2014)


    I read this article with great interest. I've not had the pleasure of being on a team that wanted to use either CI or CD. But I...


    - 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: raid 5 and database partitioning

    Um, thanks sqlVogel for that utterly useless link. Slightly funny, but utterly useless.

    fizzleme (10/27/2014)


    The documentation says put log files and tempdb on separate database partitions. We use raid...


    - 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: CI and CD Aren't Magic

    CI works in the app development world because of a particular idea: non-persistance of the layer. I'm not discussing the concept of CI, but the reality of its implementation....


    - 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: Discrepant Variable Values SSIS and DTSX

    Just to confirm, you're rt-clicking the dtsx and opening it in, say, Notepad++, then moving down to the DTS:ConnectionManager with the "ObjectName" for your connection in the package, and looking...


    - 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: More Records After Filtering

    There is a difference in the pra.ID = xx(x) line. Safe to assume that's a typo?

    Offhand I don't see any reason you should be returning more rows. I'd 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: Need Help with Stored Procedure

    Mr. Celko, I have I a request.

    Please either go away with extreme prejudice, or bring the personality that you (apparently, due to source I trust) have in real life 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: Sending multiple emails

    Short answer: Drop off the email and the name into an ADO Recordset object from a dataflow (feed your select statement into a recordset target).

    Use that object variable as 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: Hyper-V replication instead of SQL Server Mirroring

    Hyper-V in particular isn't something I've used, but other clone softwares are things I've witnessed. The are avoided like the plague simply because the database is basically trasferred 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: Another Issue with Stored Procedures

    It comes down to the fact that you've built a large parameter list at the top, and you're expecting that to be the declaration for all local scopes. Think...


    - 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, this should be interesting... *grabs popcorn*

    Sic 'im, Scott!


    - 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: Temporary Tables Causing Stored Procedure Recompiles

    Nick Doyle (10/9/2014)


    I found the following blog post from Paul White, which has helped clarify the situation and provide some context for Eddie's rules:

    http://sqlblog.com/blogs/paul_white/archive/2012/08/15/temporary-tables-in-stored-procedures.aspx

    Thanks for the link Nick. I'm...


    - 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: Temporary Tables Causing Stored Procedure Recompiles

    Eddie Wuerch (10/8/2014)


    1. Do not drop #tables when you are done with them - let them go out of scope at the end of the proc and allow...


    - 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: I need some guidance on real time SSRS applications

    Nope, because that depends entirely on where you work. Do you have BA's and PM's? Are you working against a warehouse that's built by a data architect, or...


    - 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 Help with Stored Procedure

    Sincerely appreciate you being honest about this is for a class. You'd be surprised.

    So, with that in mind, what you're running into is a topic called "Implicit Conversion". ...


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