Why is "select *" faster than "select top 500 *" in SQL Server?
13678
'SELECT TOP' performance question
103235
When a previously-fast SQL query starts running slow, where do I look to find the source of the issue?
64636
udf vs direct sql performance
44138
Why is SQL Server 2012 Recommending This Index Be Created?
10642
SQL Server - what isolation level for non-blocking select statements?
1408
SQL JOIN vs IN performance?
127977
SQL Server Select top 10-20 results?
135864
Does column ordering affects performance in Microsoft SQL Server 2012?
39136
System.QueryException: Non-selective query against large object type (more than 200000 rows)
43308
What is the difference between select count(*) and select count(any_non_null_column)?
97859
SQL Server query runs slower from ADO.NET than in SSMS
133376
Optimizing a simple mysql select on a large table (75M+ rows)
34096
LEFT JOIN vs. LEFT OUTER JOIN in SQL Server
138284
Are individual queries faster than joins?
31259
Re-arranging / selecting of a data table very slow in For loop
108832
Is a join optimized to a where clause at runtime?
23118
MIN/MAX vs ORDER BY and LIMIT