Posted by --CELKO-- on 01/31/06 03:20

>> I never knew that ordering a view was unsupported. It always has worked, I bet it always will, but it is good to know. <<

Not the way to bet. Are you old enough to remember when GROUP BY did a
sort and T-SQL dialect-only programmers wrote code that depended on
that single-processor sort model? Things blew up after 6.5 because
they wanted to save a few keystrokes and to violate standards (or as I
call it "Speaking Hillbilly SQL").

The advantage of following standards is that you can escape the
contigous files/ contigous records physical model for MUCH better
implementations, parallelism, etc.

[Back to original message]