george sibbald (1/16/2013)
Ratheesh.K.Nair (1/15/2013)
Dev team have created queries to remove duplicate records from DB and it is removing this many records per year starting from 2009. Is it good or will it cause any overhead. Database is in SIMPLE recovery mode so log growth is not am concerned about.If the deletes are batched up you won't have log growth problems but if the delete is one large transaction you could still get log growth problems
The query is deleting duplicate records its fetching data using cursor.