Daniel Hutmatcher shows an interesting line of demarcation:
But there’s a built-in (undocumented) shortcut optimization in SQL Server. If you’re returning no more than 100 rows, the internal behaviour of the Top N Sort operator changes.
Read the whole thing.