Dave Ballantyne
SSC-Dedicated
Points: 33667
More actions
September 7, 2009 at 3:06 am
#210413
Here's a quick blog on an effect i noticed last week.
I couldnt find any thing by googling around.
Nor could i see any fixes in later Cumulative updates.
http://sqlblogcasts.com/blogs/sqlandthelike/archive/2009/09/08/bug-use-of-ranking-functions-result-in-an-inefficient-query-plan.aspx
RBarryYoung
SSC Guru
Points: 143329
September 7, 2009 at 7:01 am
#1050096
Good analysis and writeup.
And yep, I'd agree, looks like an optimizer bug in SQL Server 2005, though as you imply, it seems to be fixed in 2008.
[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]
September 8, 2009 at 1:38 am
#1050335
Connect bug report raised here.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply