Forum Replies Created

Viewing 15 posts - 3,676 through 3,690 (of 7,164 total)

  • RE: data pump into MySQL

    Here is an example for you. It requires no third party components and modification of only a few lines of VB.net code to get working with your chosen ODBC connection,...

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

    June 29, 2012 at 8:20 pm

    #1507414

  • RE: backup thread in a wiat state for the last 2 days.

    Ultimately it is your call but I do not anticipate any issues with killing those threads in terms of you ending up with a corrupt database, but it is master...

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

    June 29, 2012 at 8:15 pm

    #1507413

  • RE: SQL Server Certs

    Lynn Pettis (6/29/2012)

    opc.three (6/29/2012)

    Lynn Pettis (6/29/2012)

    I can think of at least one person on SSC that would disagree, but I'll leave it to Brandie to explain why.

    I am curious to...

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

    June 29, 2012 at 3:44 pm

    #1507356

  • RE: Column property change

    jdbrown239 (6/29/2012)

    Thanks opc.three that helped alot.

    You're welcome, have a good weekend.

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

    June 29, 2012 at 3:39 pm

    #1507351

  • RE: backup thread in a wiat state for the last 2 days.

    BACKUPIO - Occurs when a backup task is waiting for data, or is waiting for a buffer in which to store data. This type is not typical, except when a...

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

    June 29, 2012 at 3:38 pm

    #1507350

  • RE: SQL Server Certs

    Lynn Pettis (6/29/2012)

    I can think of at least one person on SSC that would disagree, but I'll leave it to Brandie to explain why.

    I am curious to hear her thoughts....

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

    June 29, 2012 at 3:33 pm

    #1507345

  • RE: Need help with Migration from 2005 to 2008

    Upgrading Integration Services Packages to SQL Server 2008 R2

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

    June 29, 2012 at 2:36 pm

    #1507321

  • RE: SQL Server Certs

    BKF (6/29/2012)

    I need to obtain the SQL Server 2008 Implementation and Maintenance cert ASAP

    Who or what is creating this sense of urgency?

    Can anyone give me an idea how best to...

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

    June 29, 2012 at 2:33 pm

    #1507319

  • RE: backup thread in a wiat state for the last 2 days.

    Any other threads on the instance with a different backup wait type, e.g.

    BACKUP - Occurs when a task is blocked as part of backup processing.

    BACKUP_CLIENTLOCK - Internal only.

    BACKUP_OPERATOR -...

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

    June 29, 2012 at 2:18 pm

    #1507315

  • RE: data pump into MySQL

    With SSIS 2008/2012 it is easy using a builtin component, but with 2005, sadly, it is not. Check Pragmatic Works for a third party component. I think they have one...

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

    June 29, 2012 at 1:21 pm

    #1507284

  • RE: data pump into MySQL

    cmoy (3/23/2012)

    I have massive amounts of data that I need to put from 2008 into MySQL every hour. I would like to invoke MySQL's LOAD Data functionality (somewhat equivalent...

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

    June 29, 2012 at 1:05 pm

    #1507274

  • RE: How Can I Update Data From An Email Attachment ?

    clucasi (6/11/2012)

    I need to update SQL 2005 from an email attachment, which is a delimited Excel 2010 file. The same named file is delivered to me with updated data throughout...

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

    June 29, 2012 at 12:56 pm

    #1507267

  • RE: How to determine when column stats are updated?

    GilaMonster (6/29/2012)

    opc.three (6/29/2012)

    You may have something very granular or customizable planned in terms of your scripting effort so this may not be applicable, or these options may not satisfy your...

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

    June 29, 2012 at 12:32 pm

    #1507258

  • RE: SSIS 2005 package with mysql as destination

    Thanks for providing me with a good chuckle on a Friday afternoon 😛

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

    June 29, 2012 at 12:05 pm

    #1507248

  • RE: How to dicrease the ram utilization

    dan-572483 (6/29/2012)

    Related question: Is leaving the default memory settings in place sometimes better, or is it always better to manually configure the memory settings?

    It depends somewhat on your installation, e.g....

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

    June 29, 2012 at 10:44 am

    #1507217

Viewing 15 posts - 3,676 through 3,690 (of 7,164 total)