Viewing 3 posts - 181 through 184 (of 184 total)
... Furthermore without the ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW it would be slow because with the default RANGE-parameter it has to spill out to TempDB.
ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
June 6, 2016 at 1:24 am
#1883301
@topic:
- you should never use FIRST_VALUE without "ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW", otherwise it will always spill out to TempDB -> slow
- for this reason I prever to...
June 3, 2016 at 12:41 am
#1882994
Yes - it seems so. But please don't ask me, if this is a bug or intended behavior (I tend to bug or at least misbehavior, because MSSQL usually do...
May 20, 2016 at 12:26 am
#1880430