database do sorting whenever the query has "join" or "order by" or "group by".... I know Oracle can configure sort_area_size to do the sorting in memory. Can sybase and sqlserver sort in memory as Oracle does?

My understanding of sort in Sybase and sqlserver is that the sort is done in tempdb mostly, which involve in disk io on tempdb and get poor performance.

Any idea?