Comments by Dennis.D.Allen

Dennis.D.Allen 6-Dec-10 10:14am View

Deleted

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

Deleted

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

Deleted

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

Deleted

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.

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