• 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.