Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Lopaka
Starting Member
48 Posts |
 Posted - 2009-12-15 : 14:17:21
|
| I created a simple Int field in a table with 26 million rows. Tried to populate the field incrementally:Update TableSet Field = @i + field + @i + 1Let it run for 9 hours, still didn't finish. I then tried the same thing, but updated a field with NULL. Same thing.Question is, is there something I am doing wrong or is there something wrong with the database?Thank youRobert R. BarnesRobert R. Barnes |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
|
|
|
|
|
Really slow update...