Home Forums SQL Server 2012 SQL Server 2012 - T-SQL How to improve this query RE: How to improve this query

  • 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/

    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: