Thanks for relying Gila

I don't know of this concept.

However it's a 3rd party DB I cannot make changes to it.

As a simplified model I THOUGHT Sql executed the locking as it sees fit or instructed to do and places the results into temp store (memory/tempdb?). It then releases locks and starts sending the data.