Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Run Stored Procedure without Writing to Transaction Log? RE: Run Stored Procedure without Writing to Transaction Log?

  • February 26, 2015 at 8:57 pm

    #1780459

    Hmm. If you are deleting a large fraction of a table it is often best to drop existing non-clustered indexes and then rebuild after DML.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service