Home Forums SQL Server 2012 SQL 2012 - General Windows Function RE: Windows Function

  • October 26, 2016 at 9:36 am

    #1908929

    drew.allen (10/26/2016)

    Jeff Moden (10/25/2016)

    As a bit of a sidebar, it would have been nice if they had it default to a ROWS specification because it's faster than the RANGE specification.

    The reason that they used RANGE instead of ROWS is that RANGE is deterministic whereas ROWS is not when there are ties in the order by clause.

    Drew

    Curious how you might know why MS decided that. Is there a bit of MS documentation that states that's why they chose RANGE for the default?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)