SQL Server shows huge decrease in performance when query is written like:
select top 101 name from Dogs order by name
compared to select top 100.
As far as I know, this happens for the reason that SQL Server in a
top 100+ query simply orders all dataset and picks top records (while top 100 and less queries use more sophisticated algorithm).
Are there any workarounds for this?