Note: under certain conditions the solution can return degenerate intervals (where starttime = endtime). Those are of course meaningless when the interval is a closed-open interval like in our...
This works fine for me (using the sample temporal table from the article):
CREATE VIEW dbo.V1 WITH SCHEMABINDING
SELECT empid, empname, sysstart, sysend...
Thanks jc_ojo, that's fixed now.
This is a good point. Since the seek predicate shows only "number >= @2" you would think that even for the minimum applicable number (9 in our example) SQL Server would have...
It could be that you don't have enough CPUs in the machine to justify a parallel plan in this case. For this query, you need 8 or more CPUs to justify a parallel plan. If you...