Thread: Query memory
View Single Post
  #1 (permalink)  
Old August 29th, 2010, 12:22 PM
jmamed jmamed is offline
Registered User
Join Date: Aug 2010
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Post Query memory


Thank you for very informative book.

On page 54 of query memory section:

"Query memory is used to temporarily store results during hash and sort operations ..."

My understanding is for sort type operation whenever is not enough memory available then tempDB will be used.

But, you have not mentioned tempDb here. When you say result of operation; do you mean that engine might sort the data on tempDB but, must have a memory to store all the results of operation?

Can you ,please clarify?