i have two tables. One is Staging (about 20kk records) and the dimension with 4 records.
I do update with:
set t.column2 = t2.column2
from table t1
join table2 t2
on table.column1 = table2.column1
it is the simpliest update. But he isn't running. In Activity Monitor i see that this query put on "Suspended" status and PAGEIOLATCH reason.
But this query is the only running in the server. No one can lock this query..
What can be?
View Complete Post