Get better query performance by using these TOP tips
Proper indexing can help speed up sorting operations. In "Tuning of a Different Sort," December 2001, InstantDoc ID 22927, I stressed that sorting (as when you use ORDER BY) applies only to the result set because the data in a relational database table has no specific order. Another T-SQL construct you can use in a query's SELECT list to limit the number of rows returned is the TOP clause. TOP is similar to ORDER BY in...