Jan 11, 2014

I am back now :)

After a long time, I am thinking to write again.. Hope I can continue writing :)

Dec 7, 2011

Best Practice for deleting large records from a table

Request Timed out for Large Table records delaetion.
Even sometime it sayes Transaction Logs Full, or sometime Memory Issues...
So here i get the Best Practice for deleting large records from a table...

WHILE (SELECT COUNT(*) FROM <table name> WHERE [Filter Condition] > 0
BEGIN
DELETE TOP 10 FROM <table name> WHERE [Filter Condition]
END