Forum Replies Created

Viewing 15 posts - 46 through 60 (of 7,164 total)

  • RE: Reindex maintenance plan error

    KenpoDBA - Wednesday, August 23, 2017 7:06 AM

    Orlando Colamatteo - Wednesday, August 23, 2017 6:31 AM

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

  • RE: Data flow concept - Thoughts wanted

    Phil Parkin - Wednesday, August 23, 2017 5:42 PM

    Tom_Hogan - Wednesday, August 23, 2017 4:56 PM

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

  • RE: Using Dynamic Query in a Transact SQL Select

    A few things about this:

    1.) This would be very difficult to achieve in T-SQL

    2.) Why would you want to do this? There are much better tools already available (e.g. Mathematica)

    3.)...

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

  • RE: Data flow concept - Thoughts wanted

    Tom_Hogan - Wednesday, August 23, 2017 7:11 AM

    Jeff Moden - Tuesday, August 22, 2017 8:50 PM

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

  • RE: Best Approach For Junction Table Mainrenace

    vincentshanecurtis - Wednesday, August 23, 2017 12:35 AM

    OK so it is possible to do cascading deletes in Server, good to hear. I'll...

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

  • RE: Reindex maintenance plan error

    KenpoDBA - Wednesday, August 23, 2017 3:55 AM

    Orlando Colamatteo - Tuesday, August 22, 2017 11:48 PM

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

  • RE: Reindex maintenance plan error

    SQLRNNR - Wednesday, August 23, 2017 12:42 AM

    Orlando Colamatteo - Tuesday, August 22, 2017 11:48 PM

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

  • RE: Audit table

    Enabling Package logging is the simplest way to capture the information with no custom engineering involved to capture the data. Selectively turning on certain logging events for a Data Flow...

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

  • RE: Polling and determine the status of a job?

    info 58414 - Monday, August 14, 2017 9:29 AM

    Hi,

    I want to get a message from a RemoteServer when a certain SQL job...

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

  • RE: Flat File with out headers

    I agree with Jeff, are you splitting the file or is it arriving to you in this way? I see no need to split it.

    A simple PowerShell script...

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

  • RE: Reindex maintenance plan error

    SQLRNNR - Tuesday, August 22, 2017 11:39 PM

    Orlando Colamatteo - Tuesday, August 22, 2017 11:10 PM

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

  • RE: Downside of a large number of script tasks in SSIS projects?

    ash.j.hoff - Monday, July 17, 2017 5:26 PM

    Hi Folks,
    I am currently working on a SSIS project that has many sub packages, being...

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

  • RE: Data flow concept - Thoughts wanted

    Converting incoming CSV files to XML in a generic field-name/field-value format will help solve the integration problem for you quite quickly by allowing you to then use one SSIS Package...

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

  • RE: Restore production database to other environments

    Depends on what else is using the thing behind the UNC path, how reliable the connection to it is and how fast the server doing the restore happens to be....

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

  • RE: Reindex maintenance plan error

    TheSQLGuru - Tuesday, August 22, 2017 9:43 PM

    Ola.hallengren.com is my go-to solution for MX.

    +1 for Ola's solution

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

Viewing 15 posts - 46 through 60 (of 7,164 total)