Lynn Pettis (4/27/2009)
ALZDBA (4/27/2009)
As you suggested the "Order by" testing with Jeffs solution, I also tested your marvellous solution for partitioned objects.First findings .... It no longer works .... SQL2008 ( sp1 ) is getting smarter.
The more things we try to fool it, it just ignores them.
They must have a huge pile of fools, to anticipate all the foolish things we try 😀 (forcing a sets processing in a certain order.)
I'm still trying to figure out why ..... or why not.
Okay, I really need to get SQL Server 2008 Developers Edition. Have you tested the ORDER BY on the partitioned table itself?
Lynn, try here. $45 is pretty good, and because I'm an Amazon Prime customer, I get the 2-day shipping free.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]