116 reputation
1
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.