 |  |  |  |  |  |  |  |
SQL Server 2005 Delete 1 Million Records
 |
Hi
We have got a single instance of SQL Server 2005. The latest service pack 3 has been installed today. Since installing SQL Server two months ago we are finding that SQL Server times out if you try to delete records from any table that has more than 600,000 records.
So on our table with 1 million records if we say "DELETE FROM tbl" then it times out. Deleting the Top say 600,000 records works.
We do not want to use TRUNCATE as this would mean modifying lots of code in our application.
Also the same promlem is experienced when using UPDATE.
Many thanks for your help
We have got a single instance of SQL Server 2005. The latest service pack 3 has been installed today. Since installing SQL Server two months ago we are finding that SQL Server times out if you try to delete records from any table that has more than 600,000 records.
So on our table with 1 million records if we say "DELETE FROM tbl" then it times out. Deleting the Top say 600,000 records works.
We do not want to use TRUNCATE as this would mean modifying lots of code in our application.
Also the same promlem is experienced when using UPDATE.
Many thanks for your help
|
Other Threads in the Windows NT / 2000 / XP Forum
- Previous Thread: NEED help for configuring DNS for run a website.
- Next Thread: Windows update won't start/load.
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest Windows NT / 2000 / XP Posts
- Today's Posts
- Unanswered Threads
.net 64bit 2007 2010 a.exe address apache appstore arm automatically black blue book bsod bulletin canonical cellphones chkdsk codeplex computer crash cursor deployment deployments desktop desktops dns dotnetnuke drive eartlink error errors explorer fax features folder fontmanagers format framework freeze hardware home internet interoperability laptop linux load login mac memory microsoft monitor motionle1600 netbooks novell nvidia open operatingsystems options osx palm partition patch printer product program proxy reformat remotedesktop repair replacingraiddrive retail retrieve screen security sharepoint simplifiedchinese sitetositevpn slowperformance technology update usb verizon videodrivers videogames virus vista visual vpn vulnerability wab win win32/heur windows windows7 windowsxp windowsxpnotstartingup. worm xp xpde
