Itis understood that clause "order by" will use tempdb. However, the temporary space in this case is fully controlled by SQL Server v6.5 If I encountered deadlock because I...