| bio | website | |
|---|---|---|
| location | Missouri | |
| age | 30 | |
| visits | member for | 1 year, 11 months |
| seen | Jun 1 '12 at 21:21 | |
| stats | profile views | 12 |
A follower of Christ, bookworm, outdoorsman, musician. Please see my Area 51 proposal for a Microsoft CRM site: http://area51.stackexchange.com/proposals/32455/microsoft-crm
|
Jun 24 |
comment |
Why did my UPDATE statement not complete? The rows are not deleted by this update statement. Only one field for each row is updated. |
|
Jun 24 |
comment |
Why did my UPDATE statement not complete? The clustered index update, for the primary key, takes up a majority of the query cost at 65%. The other heavy hitters are 2 Table Spool (Eager Spool) at 24% |
|
Jun 22 |
comment |
Why did my UPDATE statement not complete? I have non-clustered indexes on the columns in the first update query that I tried to update 1 row from. I re-built all of the indexes but no change in execution. |