Posted by serge on 01/14/06 05:36

> But I'm afraid I don't have very many ideas.

I wanted to find out if someone knew or had encountered this
weird problem or may have heard it as a SQL bug or something.
Basically I was hoping that this was a known issue and there
was a simple explanation to it.

> Did you study the query plan to see if they were identical in
> both cases?

It was a big plan that I had waited for around 35 minutes before I
got it. There were I think 2 statements of INSERT to a #temp table
taking about 32% each so that seemed to be the big overhead in the
execution plan.

This problem is very intriguing. Yesterday I ran your version of
sp_lock but I don't really know how to interpret sp_lock etc...
I'll have to read a couple of chapters on locking and spend a
number of hours to learn this stuff, experiment and see what
I'll manage to learn out of this.

I am sure it will be painful but rewarding as I'll get a chance
to learn about locking and much more.

If I do end up finding any interesting information I'll post it here.

Thanks Erland.

[Back to original message]