The Query Optimizer is good at working out the best way of getting what you want, far better than you. It works out the best plan, based on what you...

Crazy idea, does anyone know what version the memory leak on stats was in? If I recall there is some sort of memory leak with auto update stats async on....

Mauve (12/3/2013)

---

Now for all of you that think a "SELECT * FROM..." would return the rows in PK (IDENTITY) order, you are wrong!

The SQL Server optimizer, in this case will...

I could be wrong but if you pop the server into single user mode and an index that uses a as a lead column will return results in order every...

Yes it will if the non cluster covers the query which in the case of select a from #temp order by a will do as it can scan the index...