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.


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


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