Viewing 5 posts - 196 through 201 (of 201 total)
Nice article, but
- minus point for the usage of [dbo].[udfBuildISO8601Date] (UDFs are slow); there is a built in function DATEFROMPARTS() with the same syntax, that outputs a date. If necessary...
God is real, unless declared integer.
June 10, 2016 at 9:56 am
I'd say, that - depending on which index it uses and / which other sorts it has to do / when you are MERGE joining / going parallel / are...
God is real, unless declared integer.
June 7, 2016 at 12:36 am
... 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.
God is real, unless declared integer.
June 6, 2016 at 1:24 am
@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...
God is real, unless declared integer.
June 3, 2016 at 12:41 am
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...
God is real, unless declared integer.
May 20, 2016 at 12:26 am
Viewing 5 posts - 196 through 201 (of 201 total)