Emil B
SSCertifiable
Points: 5568
More actions
September 4, 2015 at 10:48 am
#1824745
Luis Cazares (9/4/2015)Emil B (9/4/2015)was this ROWS/RANGE "hint" available in 2008/R2?No, neither the ORDER BY for window functions.But the Quirky Update is supposed to be even faster. For more information: http://www.sqlservercentral.com/articles/T-SQL/68467/
Luis Cazares (9/4/2015)
Emil B (9/4/2015)was this ROWS/RANGE "hint" available in 2008/R2?
Emil B (9/4/2015)
No, neither the ORDER BY for window functions.
But the Quirky Update is supposed to be even faster. For more information: http://www.sqlservercentral.com/articles/T-SQL/68467/
Ahh... that explains why i haven't seen it in use before. That's my second week working on 2012.
Thanks for the reading Luis, I'll leave it for Monday :hehe:
Viewing post 16 (of 15 total)
You must be logged in to reply to this topic. Login to reply