sql register mislay query over millions rows performance

this an adventure. i started looping register query located , nonetheless any loop over 17 million records, meaning take weeks (just controlling *select count * mytable* takes server 4:30 mins controlling mssql 2005). i gleamed information site during .

and have arrived during query below. doubt is, repremand form query run 17 million annals any form performance? isn't, is?

sql query:

delete tl_acxiomimport.dbo.tblacxiomlistings
where recordid 
(select recordid
    tl_acxiomimport.dbo.tblacxiomlistings
    except
    name recordid
    (
        name recordid, rank() over (partition businessname, latitude, longitude,           phone method webaddress desc, caption1 desc, caption2 desc ) rank
    tl_acxiomimport.dbo.tblacxiomlistings
    ) al where arrange = 1)