InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 09:52:19 GMT20http://www.sqlservercentral.com/Forums/Topic1367760-149-1.aspx[quote][b]rahim.shabbir (10/3/2012)[/b][hr]i have a database and a table with 498591 records.I have a sql script which remove duplicates./quote] whenever you are dealing with high volume of data you need to think about batch approach (deals in chunks with data)Thu, 11 Oct 2012 01:10:19 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1367760-149-1.aspxEither you need to rework on your script, something like using table variable that shall take top 5000 records and delete it, put it in a while loop till all records are deleted, it seems that your script is trying to delete all the records in one go forcing tempdb to fill.Else you may want to create another tempdb log file to another drive where ample space is present.Fri, 05 Oct 2012 08:01:57 GMTSameer Kapurhttp://www.sqlservercentral.com/Forums/Topic1367760-149-1.aspx[quote][b]rahim.shabbir (10/3/2012)[/b][hr]The script works as its been tested by our coding department. Is there anything else i can do?[/quote]Obviously your coding department didn't test it for scalability because it's not working for you. There's likely a "Triangular Join" in the script that's generating billions of internal rows that TempDB is trying to store.Post the code and the table definition (CREATE TABLE) or we just won't be able to help. I recommend that you take a look at the second link in my signature line to get the best help possible on this problem.Wed, 03 Oct 2012 16:07:55 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic1367760-149-1.aspxThe script works as its been tested by our coding department. Is there anything else i can do?Wed, 03 Oct 2012 09:36:55 GMTReemi12http://www.sqlservercentral.com/Forums/Topic1367760-149-1.aspxYou could post the script - sounds a bit slow-running!Wed, 03 Oct 2012 09:17:21 GMTlaurie-789651http://www.sqlservercentral.com/Forums/Topic1367760-149-1.aspxHi,I just started using SQL server management Studio, i have a database and a table with 498591 records.I have a sql script which remove duplicates.Whilst running the script, 2.5 hours later i get a popup saying space on E:\ is running low.At the end it said query completed with errors, "The Transaction log for the database 'tempdb' is full".I checked the E:\ and it was full, only had 10mb available, E:\ is also where the tempdb file was.What would be the best course of action? I assume i need to rerun the script again as there is still 498591 records.Wed, 03 Oct 2012 09:03:13 GMTReemi12