Viewing post 1 (of 2 total)
In terms of the delete (and depending on indexes), instead of using "IN" in your where clause, I'd use something like:
DECLARE @Id INT
SELECT @Id = MAX(Id) FROM (SELECT TOP 3000...
July 5, 2011 at 11:38 pm
#1348743