Click here to Skip to main content
15,507,526 members

Comments by Dennis.D.Allen (Top 4 by date)

Dennis.D.Allen 6-Dec-10 10:14am View    
Reason for my vote of 1
There is no performance difference between a select of literals verses a values of literals.

The real difference is that select can be from some data source while values will always be directly specified.
Dennis.D.Allen 6-Dec-10 10:12am View    
Reason for my vote of 5
Agree better proof needed, and I know from personal experience and testing that a select of 2 columns verses a values of the same will not have a measurable difference.
Dennis.D.Allen 6-Dec-10 10:04am View    
Reason for my vote of 2
There are better techniques that focus on fetching the part rather then finding some comments.
Dennis.D.Allen 29-Nov-10 10:04am View    
Shouldn't you be specifying the column name for the @sortby value rather than values from the first row?

The 2nd solution is better due to dates being compared for sorting as dates rather then an unknown date format. It works as expected if your format is one that is like YYYY-MM-DD but often the default date format is MM/DD/YYYY or YYYY-MMM-DD even would put August before February.