Tag Archive for 'sort'

Is Distinct A Synonym To Order By In MS SQL Server ?

1 Comment
July 10th, 2009 by Waldar

This afternoon, I was chatting with Antoine Gémis about T-SQL, and this subject came on the table.
He was asking if, in my opinion, using both a distinct and an order by in the same statement would make the query worst due to the fact that distinct is already performing a sort on his own.
Working mostly [...]

SQLing , , , , , , , .

TSQL Challenge #10, How To Process Horizontal Sorting

Add a comment
June 24th, 2009 by Waldar

Beyond Relational have released their last T-SQL Challenge, it’s already number 10 !
French version has been translated on Antoine Gémis’s blog.
Jacob Sebastian and the TC team is really active and involved in helping people to improve themselves with SQL and T-SQL.
For this challenge they offer a Free Training Webcast for those who have problems in [...]

SQLing , , .