David Portas (4/27/2010)
TheSQLGuru (4/27/2010)
Tables are UNORDERED sets of data unless they have a CLUSTERED INDEX on them.Tables are unordered sets even if they do have a clustered index. A clustered index is just one form of internal storage. It doesn't impose any logical ordering any more than a nonclustered index on a heap does.
Heh... obviously not a fan of WITH (INDEX(0)) or the "Quirky" Update, huh?
--Jeff Moden
Change is inevitable... Change for the better is not.