Home Forums SQL Server 2008 SQL Server 2008 Administration delete a large amount of rows in a table RE: delete a large amount of rows in a table

  • February 27, 2013 at 2:08 pm

    #1591727

    What percentage of the rows are you keeping and how many rows are there in the tables?

    At some point its easier just to loop a delete statement depending on how much data you are getting rid of.

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]