Home Forums SQL Server 2005 Administering Deleting records from a huge table RE: Deleting records from a huge table
Sanz
Hall of Fame
Points: 3412
More actions
February 8, 2010 at 10:54 am
#1115674
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 ??