I must have misunderstood what a clustered index does or how it is
displayed. I have created a clustered index on a table using ...
'CREATE CLUSTERED INDEX transID ON #tmpTransactions
However when I do a 'select * from #tmpTransactions', the field does not
appear sorted. The values will be sorted for a while (probably just do
the their natural order in the table) and then they will break the sort
57126, 57127, 56705 and then 56706.
It was my understanding that a clustered index physically ordered the
table. Did I misunderstand this or did I ...