There are so many sorting algorithms, but I want to know which algorithm is used in SQL Server when we use Order by and without Order by.
Order by