Dec 24, 2005 01:06 PM|cathal|LINK
the problem with deleting rows is that the deletes will be recorded in the transaction log to protect integrity. As the log grows in size it can consume too much space/cpu and cause problems itself. The best way to clear down a table is to use "truncate
table nameoftable" , which will delete all the rows, and only add a single entry to the sql transaction log. Ideally before you do this, if you have DTS/enterprise manager access, I'd recommend you export the rows out to a downloadable source such as excel/access
so you can diagnose what the issue(s) are.