Forum Replies Created

Viewing 15 posts - 3,511 through 3,525 (of 7,164 total)

  • RE: DBCC Hangs

    Also, if you ran it with DATA_PURITY through Ola's scripts last week but without it over the weekend that could explain the difference in time.

    PS as long as it had...

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

  • RE: SQL Server Certs

    BKF (7/23/2012)


    Good answer! I'm working through the material and have taken a practice exam. I'm closer then I thought, but not quite there.

    If you do not mind sharing a bit...

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

  • RE: SQL 2008 Performance is slowing down

    That is not nearly enough info for us to begin helping.

    How to Post Performance Problems by Gail Shaw[/url]

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

  • RE: How Express, Developer and Enterprise differ as remote connection tools

    If you only install Express you'll be missing server management tools like Profiler. Here is a good rundown:

    What does this Express Edition look like, anyhow? By Tibor Karaszi

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

  • RE: index fill-factor

    GilaMonster (7/22/2012)


    opc.three (7/22/2012)


    I suspect if someone were to get serious about using fn_dblog to count 'middle page splits/sec' they could somehow achieve this by referring to the object to find...

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

  • RE: Rename the existinng File at same location

    Jeff Moden (7/22/2012)


    opc.three (7/21/2012)


    Jeff Moden (7/9/2012)


    Koen Verbeeck (7/9/2012)


    SSIS can rename files. I do it all the time.

    It just happens to be that with a script task using .NET I have...

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

  • RE: For loop vs File watcher vs WMI Event watcher in SSIS 2005

    This article explores, compares and contrats some of the issues being discussed here: Using the WMI Event Watcher Task in SSIS to Process Data Files [/url]. The article demo is...

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

  • RE: index fill-factor

    I was aware of Jonathan's work in this area with EE on 2008 but had not kept up with the latest developments on 2012. The Xevent A Day series he...

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

  • RE: Today's Random Word!

    Daniel Bowlin (7/22/2012)


    bleary

    weary

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

  • RE: index fill-factor

    Robert Davis (7/21/2012)


    opc.three (7/20/2012)


    not sure how you calculated it using fn_dblog

    Page splits have a Transaction Name of 'pagesplit'. It's just a matter of counting them and dividing by the number...

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

  • RE: Rename the existinng File at same location

    Jeff Moden (7/9/2012)


    Koen Verbeeck (7/9/2012)


    SSIS can rename files. I do it all the time.

    It just happens to be that with a script task using .NET I have more control over...

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

  • RE: Consolidate data from branch offices to central database!

    Have you evaluated Merge Replication?

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

  • RE: SSIS Contract Management and data quality / lineage

    Jeremy Brown (7/20/2012)


    Hi everyone!

    I'm looking for a few good design examples for how someone has thought about SSIS WRT contract management, data quality, and data lineage reporting.

    For example, there are...

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

  • RE: Inserting fails when importing flat file to SQL Server

    Looks like a data conversion error. Can you confirm there are no lines in the file where that field is empty? You may want to change your derived column expression...

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

  • RE: How to configure Sql Server Agent?

    george sibbald (7/20/2012)


    You have SQL2008R2 so you get database backup compression with the product

    run commands

    sp_configure 'backup compression',1

    reconfigure

    to enable it.

    the just set up a maintenance plan to do your backups,...

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

Viewing 15 posts - 3,511 through 3,525 (of 7,164 total)