• The table is 135 GB in size. There are 5 columns all of which have datatype int and varchar(15).

    I would keep George's suggestion as an option (Inserting into a new table) as I will be deleting nearly 50% of the data.

    Any better idea ??

    Sanz