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


at

1 comment:

  1. AnonymousDec 9, 2012, 3:33:00 AM

    Hello there, You have done a great job. I’ll

    certainly digg it and personally recommend to my friends.
    I am sure

    they'll be benefited from this website.
    Also visit my homepage : Televisionspain.net

    ReplyDelete

Subscribe to: Post Comments (Atom)

SQL - Difference between CAST,CONVERT and PARSE

TODO---