How does the TOP, DESC and CROSS APPLY make this query faster?
11390
In what order does execution on WHERE and ON clauses work?
138284
Are individual queries faster than joins?
46885
How to get second largest or third largest entry from a table
142592
Simple SQLServer PIVOT/Transposed query, how to write?
121093
Join Query effects natural ordering
86649
What's the most efficient way to select the last n rows in a table without changing the table's structure?
103080
slow query with fulltext and left join
22982
Most efficient way to call same Table-Valued Function on multiple columns in a Query
149745
Simulate FULL OUTER JOIN with Access on more than two tables
133376
Optimizing a simple mysql select on a large table (75M+ rows)
156237
Efficient query to get greatest value per group from big table
18537
Why using IN(...) when selecting on indexed fields, will kill the performance of SELECT query?
58304
Why are queries parsed in such a way that disallows the use of column aliases in most clauses?
68174
Query is slow in SQL Server 2014, fast in SQL Server 2012
136720
What does OPTION FAST in SELECT statement do?
126514
Does anyone use Right Outer Joins?
23997
How do I order by multiple columns in a SELECT query?