Sql server takes too long time for update query to execute for few rows
UPDATE table1 SET col1='True'
This query takes more than 30 secs for about 6000 records. Why is it so slow?Do you have a trigger?
And see my answers here too: Why does an UPDATE take much longer than a SELECT?
精彩评论