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 |
|
DOlivastro
Starting Member
41 Posts |
 Posted - 2005-08-03 : 13:16:36
|
| Is there any reason why this statement:Update TableSet Status = 0... takes 30 minutes, while this statement:Update TableSet Text = LTrim (Text)... takes only 2 mintues? In the last example, Text is varchar (8000).Dom |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-08-03 : 16:12:16
|
| Same table? (i.e. same number of rows to update?)Is "Status" column indexed, and "Text" column not indexed?Does "Status" column have some complicated on-change processes in a Trigger or somesuch, which Text does not?Were a large number of Statsus columns NULL (and record had to be expanded to accomodate the 0)?... and maybe very few Text columns had leading spaces, so SQL optimised them out as not making a substantive change?Kristen |
 |
|
|
|
|
|
An update question