O'Reilly logo
  • Dustin Waybright thinks this is interesting:

Note that even when you do have an ORDER BY clause, in order for the query to be completely deterministic, the ordering must be unique.

From

Cover of Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012

Note

Versus using a column that has repetitive information, such as date.