Where do sorts take plan in 2000 and 2005

Last Post 28 Sep 2007 10:45 PM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

06 Sep 2007 08: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?


New Member
New Member

28 Sep 2007 10:45 PM
Is there a choice for sorting algorithm?

Acceptable Use Policy