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
rhochambeau
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?

Thanks,

Rho
SQLUSA
New Member
New Member

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


Acceptable Use Policy
---