This is clearly documented. From Books Online:
When ORDER BY is used in the definition of a view, inline function, derived table, or subquery, the clause is used only to determine the rows returned by the TOP clause. The ORDER BY clause does not guarantee ordered results when these constructs are queried, unless ORDER BY is also specified in the query itself.
Yes, even bugs are well documented.
Microsoft is saying: "Look man, for some obscure implementation reason of my engine i cannot guarantee you that the order by will work".
It seems that Microsoft agree with me
I'm going to verify if this hotfix is installed on my sql server and also i'll verify on a sql server 2008
Views don't store data. They are only saved select statements. Tables have no defined order either. An order by on a view will have no effect at all on how data is stored in the tables that view depends upon. Order By is a clause in a select that orders rows returned by the query that it is part of. Nothing else.
Yes, but i have noticed that it takes some times to "update" a view on sql server and i think that the only reason of this delay is that the view is somewhat cached in some place by the engine.
I hate to say this, but it looks like ego is getting in your way here.
"Yes, even the bugs are well documented." Really? If you honestly consider this a bug, if you really think that you know how this should work better than EVERY EXPERIENCED DBA who has replied to this thread, AND the devs at Microsoft, and even the devs at Oracle (yes, I checked your statements on that, and they are essentially incorrect, per Oracle), then you really need to check your ego at the door.
I'm not going to grace this thread with any further coddling of you at this point. You are refusing to learn how to do the job correctly, and assuming that everyone who disagrees with you is wrong, despite the fact that EVERYONE disagrees with you. Until you are ready to actually learn how to do the job, instead of just whining about how things don't work the way you want them to, there's no point in trying to educate you. You can teach an old dog new tricks, but you can't teach anything to anyone who refuses to learn.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon