Home Forums SQL Server 2008 T-SQL (SS2K8) delete query SQL 2008 in Virtual machine setup? RE: delete query SQL 2008 in Virtual machine setup?

  • March 15, 2013 at 6:51 am

    #1597472

    How big your table is? Or, better way, how many records will stay in the table after purge of records for the last two years?

    You might find, that moving the records you want leave into new table, then dropping the original one and renaming new one back to the original will be much faster if the number of records to stay is less than number of records to be removed.

    (You will need to remove FK constraints if any ...)

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]