the below should work for you and will only take 2 seconds. Bang everyhting into temp table, truncate original and then isnert distinct values - removes duplicates

select *
into #tmp
from tbl_YOURTABLE

truncate tbl_YOURTABLE

insert into tbl_YOURTABLE
select distinct * from #tmp