Forum Replies Created

Viewing 15 posts - 316 through 330 (of 7,164 total)

  • RE: sp execution performance issue

    Please post the actual execution plans for both calls.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 3, 2016 at 9:46 pm

    #1856451

  • RE: Source control with SSIS

    chuck.forbes (2/3/2016)

    We have several different versions of SSIS, installed mostly long ago on servers alongside a particular db version (MSSQL 2005, 2008, 2012 and 2014). So for SSIS changes, we've...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 3, 2016 at 9:26 pm

    #1856448

  • RE: Help with xp_cmdshell folder creation

    Sergiy (2/3/2016)

    Ed Wagner (2/1/2016)

    If you implement this is a trigger, which is what it looks like, you'll also want to make sure the trigger performs well enough that if you...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 3, 2016 at 9:08 pm

    #1856446

  • RE: What is the True Version of Code?

    removed silly post...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 3, 2016 at 5:45 pm

    #1856437

  • RE: What is the True Version of Code?

    mister.magoo (2/3/2016)

    Orlando Colamatteo (2/3/2016)

    By the very nature of how a compiled application's deployment model works the developer or admin is compelled to go to a VCS where the plain-text class...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 3, 2016 at 5:42 pm

    #1856436

  • RE: What is the True Version of Code?

    Eric M Russell (2/3/2016)

    Orlando Colamatteo (2/3/2016)

    Eric M Russell (2/3/2016)

    Let's assume that the business requests a high priority modification to functionality currently in production. Let's also assume that the development team...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 3, 2016 at 4:01 pm

    #1856429

  • RE: What is the True Version of Code?

    Eric M Russell (2/3/2016)

    Let's assume that the business requests a high priority modification to functionality currently in production. Let's also assume that the development team has recently made an unrelated...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 3, 2016 at 3:03 pm

    #1856424

  • RE: What is the True Version of Code?

    Andy Warren (2/3/2016)

    Orlando, it's far from comical, though it does often have to do with trust and fear. We're the guardians. Sometimes we take that role too far, sometimes not...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 3, 2016 at 2:54 pm

    #1856423

  • RE: What is the True Version of Code?

    xsevensinzx (2/3/2016)

    When I create an object, it should be submitted, reviewed, tested and then pushed onto production. Any changes that avoid this process is like playing with fire. You either...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 3, 2016 at 2:25 pm

    #1856416

  • RE: SSIS Script Task and running a stored procedure

    JustMarie (2/3/2016)

    I still got truncation using the output to NVARCHAR. I'm surprised that your testing didn't show the same thing unless you didn't butt up against the limit.

    Since I...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 3, 2016 at 11:33 am

    #1856382

  • RE: Running SSIS packages from CMS server on target servers

    SQL_Surfer (2/2/2016)

    I've about 200 SSIS packages that needs to be run on 10 different instances. What is the best way to configure this dynamically? Ideally I'd like to store them...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 3, 2016 at 10:26 am

    #1856362

  • RE: SSIS Script Task and running a stored procedure

    JustMarie (2/3/2016)

    Note that in the Execute SQL Task the output needs to be a Full Result Set even though there's only one row.

    If you choose to use resultsets, yes, that...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 3, 2016 at 10:23 am

    #1856361

  • RE: What is the True Version of Code?

    Andy Warren (2/3/2016)

    Orlando, your last question seems backwards - why wouldn't we want to be able to script out/modify individual objects? Isn't that a strength?

    It is a strength and a...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 3, 2016 at 10:06 am

    #1856350

  • RE: What is the True Version of Code?

    Thanks for posting back. This is a great topic. Thanks for raising it Steve. I am hoping there are a bunch of folks enjoying their popcorn watching this one because...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 3, 2016 at 9:32 am

    #1856335

  • RE: What is the True Version of Code?

    Eric M Russell (2/2/2016)

    From the perspective of a DBA, I'm sure most of us would prefer that stored procedures an views be stored in clear text and that we have...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 2, 2016 at 4:40 pm

    #1856149

Viewing 15 posts - 316 through 330 (of 7,164 total)