Forum Replies Created

Viewing 15 posts - 3,421 through 3,435 (of 7,164 total)

  • RE: Using the Konesans File Watcher Task in SSIS to Process Data Files

    Scott D. Jacobson (8/13/2012)


    This looks neat but I have 1 question. Please pardon my ignorance as I've never used a 3rd party Task object in SSIS. Say I...

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

  • RE: Today's Random Word!

    SQLRNNR (8/9/2012)


    JAZZ Master (8/9/2012)


    Cliff Jones (8/9/2012)


    Scott D. Jacobson (8/9/2012)


    Daniel Bowlin (8/9/2012)


    Ray K (8/9/2012)


    55

    (as in, number of days until I depart for my Hawaiian vacation!!! :w00t::hehe:)

    Double nickels

    On the dime.

    Roosevelt

    Franklin

    Delano

    New Deal

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

  • RE: index with include column

    sage8 (8/7/2012)


    hi,

    from the index recommendation scripts i ran, the indexes to be created are:

    1. on column A

    2. on column A include (B,C)

    if i only created the second index: A include...

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

  • RE: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding

    This may be the GUI tming out trying to build the job history due to too much volume, or a slow or overburdened server. Does your server generate a lot...

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

  • RE: Today's Random Word!

    Revenant (8/7/2012)


    Ray K (8/7/2012)


    JAZZ Master (8/7/2012)


    SQLRNNR (8/7/2012)


    Cliff Jones (8/7/2012)


    crookj (8/7/2012)


    Scott D. Jacobson (8/7/2012)


    SQLRNNR (8/7/2012)


    Scott D. Jacobson (8/7/2012)


    JAZZ Master (8/7/2012)


    Daniel Bowlin (8/7/2012)


    opc.three (8/7/2012)


    JAZZ Master (8/7/2012)


    Scott D. Jacobson (8/6/2012)


    Rob Schripsema (8/6/2012)


    Revenant (8/6/2012)


    JAZZ...

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

  • RE: Log Shipping errors

    How to: Remove a Secondary Database (SQL Server Management Studio) - SQL Server 2008 R2

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

  • RE: Today's Random Word!

    JAZZ Master (8/7/2012)


    Scott D. Jacobson (8/6/2012)


    Rob Schripsema (8/6/2012)


    Revenant (8/6/2012)


    JAZZ Master (8/6/2012)


    crookj (8/6/2012)


    SQLRNNR (8/6/2012)


    salt n peppa

    Suga n Spice

    Snips n Snails

    Nips and Tucks

    Fits and Starts

    Bangers and mash?

    Fish and chips

    Sausage and Peppers

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

  • RE: Hash Partitioning

    I see what you're pointing out but I think the example is a bit contrived. The results seem to be skewed due to low cardinality of c3 and c4 per...

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

  • RE: Are the posted questions getting worse?

    WayneS (8/6/2012)


    For those that don't get the simple-talk newsletter, Grant has an awesome article published in today's newsletter. Catch it at http://www.simple-talk.com/sql/performance/the-seven-sins-against-tsql-performance/L[/url].

    I saw it and it is a good one....

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

  • RE: Hash Partitioning

    The nature of the clustering key will not affect fragmentation in a non-clustered index unless it is part of the non-clustered index key itself.

    In tour example c2 never becomes...

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

  • RE: Are the posted questions getting worse?

    WayneS (8/3/2012)


    Steve Jones - SSC Editor (8/3/2012)


    FYI, since some of you submit questions. I'm no longer accepting images of code.

    Please feel free to debate me.

    First, I agree with A-D of...

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

  • RE: Exiting sqlcmd with RAISERROR(50001,10,127)

    Cool. You're welcome. I upvoted the item.

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

  • RE: Exiting sqlcmd with RAISERROR(50001,10,127)

    I was able to recreate the issue you initially reported with sqlcmd v11.0. The good news is that the -b option works as advertised and stops the batch when the...

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

  • RE: Script needed for DB Full Backup to Folder on nightly task

    Richardyager (8/2/2012)


    I would use the maintenance plan wizard in SQL Server Management Studio. This is an easy tool to use. And it will automatically grab any new databases. You can...

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

  • RE: Script needed for DB Full Backup to Folder on nightly task

    Think twice three times before enabling xp_cmdshell. Enabling it exposes functionality on your SQL Server instance that are better left disabled, which Microsoft agrees with as xp_cmdshell has been disabled...

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

Viewing 15 posts - 3,421 through 3,435 (of 7,164 total)