Carlo Romagnano (12/1/2013)
steve.jacobs (11/30/2013)
Comments posted to this topic are about the item <A HREF="/questions/T-SQL/104494/">Order My Data</A>OhiOhiOhi.
The only right answer is add a "order by clause" to the select statement.
Without the order by you are not granted about the order of the data.
It depends on cpu load, memory, concurrency, parallel processing.
You can run your test and have the same result, but in the production environment you may have unexpected order.
+1.
The Only way you can guarantee ORDERED result set, is by adding ORDER BY in the Statement.
(Even Though This Question has Very Less Data, it will order the result by INDEXING, But in PRACTICAL SCENARIOS it will not work) 😉