Viewing 2 posts - 1 through 2 (of 2 total)
This seems to happen when updating 2 very large tables (over 2 million) by joining them together. My process waits on a PAGEIOLATCH and goes to sleep and SQL server doesn't...
May 1, 2007 at 9:01 am
#703556
Never mind on this. I have found the problem with the query.
Mike
April 23, 2007 at 6:26 pm
#702055