Post reply

How to delete by object of SSIS (SQL 2008 R2) ?

  • May 21, 2012 at 8:47 pm

    #258513

    Dear master,

    I have risk:

    Tables current 150,000,000 rows

    If T-SQL with below then exec about more 3 hours and log file extent to 170GB capacity

    DELETE CashTransactions

    WHERE CashTransYMD <= '201111231'

    How to delete by object of SSIS (SQL 2008 R2) ? Exec good time and extent log file

    Best,

    PhuongNH

  • May 22, 2012 at 10:00 am

    #1491184

    How many rows is your query trying to delete? What else is happening on that table while you are running your delete? Are you running the delete in a transaction with other statements? Please post the DDL for the table including all indexes.

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

  • May 22, 2012 at 11:43 am

    #1491255

    You may want to read this article, http://www.sqlservercentral.com/articles/T-SQL/67898/.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply