DELETE TOP(10000) Object1
   FROM Object1
   LEFT JOIN Object2
   ON
    Object1.TID = Object2.TID
   WHERE
    Object2.TID IS NULL

SELECT Object1.TID
       FROM Object1
       LEFT JOIN Object2
       ON
        Object1.TID = Object2.TID
       WHERE
        Object2.TID IS NULL