October 24, 2011 at 9:54 am
Perry Whittle (10/24/2011)
jared-709193 (10/24/2011)
Yes, their view definition included the TOP and ORDER BYdon't know how many times it's been said but "Don't order by in a view" 🙂
A view is essentially a table, all ordering should be done outside the view
This is straight from Microsoft
lol... Preaching to the choir. This is why it is not god to have the head software engineer also the acting DBA and database developer. Hence, why my company put together a DBA team. Still trying to pry away some of that power though.
Jared
Jared
CE - Microsoft
October 24, 2011 at 10:06 am
tell them its not preaching its fact!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 24, 2011 at 10:23 am
Perry Whittle (10/24/2011)
jared-709193 (10/24/2011)
Yes, their view definition included the TOP and ORDER BYdon't know how many times it's been said but "Don't order by in a view" 🙂
A view is essentially a table, all ordering should be done outside the view
This is straight from Microsoft
This is interesting because Microsoft is saying that this is a bug... Only in the TOP (100) PERCENT... They shouldn't treat this as a bug. Ugh...
Jared
Jared
CE - Microsoft
October 24, 2011 at 12:13 pm
A good video on the subject (clustering key): Kimberly Tripp - The Clustered Index Debate. One of a whole bunch of MCM Videos.
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply