A bit tongue in cheek and light-hearted this time. SQL Server can sort. It doesn’t generally do it well. You pay a whole lot per SQL Server CPU. Why should we spend a lot of money to have it do something it does poorly? When possible you will get performance gains from sorting in app, and make all the other database users happier.
