I am trying to update my table that has 1.5 million records on it right now its running for 5 hours and still executing query is it normal to be this long? my other database that has 500k records only took 22 minutes.
This is my query
ALTER TABLE [Character] ALTER COLUMN Inventory BINARY(3776) ALTER TABLE [Character] ADD [ExtInventory] TINYINT NOT NULL DEFAULT 0 ALTER TABLE [Character] ADD [S6EP3_PS_FIX] TINYINT NOT NULL DEFAULT 0 GO UPDATE [Character] SET S6EP3_PS_FIX = 0
Some ideas - which may apply to your situation: 1) If the table has too many non clustered indices, it is better to disable them during update and enable it again after update 2) Batch the Updates 3) Ensure all login are disconnected 4) Turn off services connecting to database
Problem is im not good in ms sql im just running this update query for my gameserver and im really frustrated that this query is running 6 hours and nothing is happening, is there anyone here kind enough to assist me i will be willing to pay for your service.
Update Query 1.5 Million Records taking 5 hours...
Posted - 11/06/2012 : 03:06:58
