Thank this author by sharing:
Query performance for Ordering
query execution order
while run the query the order of data will be different in every run.
Order by Query
Every time an SQL query is run without the ORDER BY clause, the sort order of the results returned i...
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.