Where do sorts take plan in 2000 and 2005

Last Post 28 Sep 2007 11:45 PM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
rhochambeau
New Member
New Member

--
06 Sep 2007 09:40 AM
When looking at excution plans I have a few sorts that take a long time and realized I did not know where that was occuring.

I assume that it is done in memeory in SQL 2000 but thought the sort might be done in tempdb in 2005?

Thanks,

Rho
SQLUSA
New Member
New Member

--
28 Sep 2007 11:45 PM
Is there a choice for sorting algorithm?
You are not authorized to post a reply.

Acceptable Use Policy