"What is the difference in performance between ""SELECT"" and ""SELECT DISTINCT"" and when should we use the one or the other?"
In a basic SELECT * query will the data passed over the network necessarily be significantly more than if we use a WHERE clause, TOP or OFFSET?