Add missing information for Ntile in execution plans
When the Ntile function is used in a query, its parameter is not exposed in the execution plan. For example, this query:
NTILE(36) OVER (PARTITION BY soh.OrderDate ORDER BY soh.TaxAmt)
FROM Sales.SalesOrderHeader AS soh;
Check the execution plan, and even in the XML the value "36" is not used.
Change the 36 to another value, and the execution plan is EXACTLY the same, even though the results are obviously different.
This information has to be stored in the internal representation of the execution plan, but seems to fall under the table when converting it to the showplan XML representation.
Please add a property to the Sequence Project showplan operator to expose this information.