A ranking window function that divides each partition's sorted rows into a stated number of numbered buckets. If the rows can't be shared out equally, the earlier buckets get the extra rows.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains NTILE in context, with comparison tables and the common traps.
Terms in this definition
- Window function
A function evaluated OVER a window defined by PARTITION BY, ORDER BY and optionally a frame; unlike GROUP BY aggregation it doesn't collapse rows, but adds to each one a value worked out from its related rows. Examples are RANK, ROW_NUMBER, LAG and running totals.
- Azure AI Search partition
Storage and I/O unit of a search service, each holding part of the indexes. Adding partitions increases storage and indexing throughput; the number of search units equals replicas multiplied by partitions.
- EARLIER
Within nested DAX row contexts, lets an inner calculation read a column as it stood in an outer pass; EARLIEST jumps to the outermost. Most people now use variables, which read more clearly.
- Get
Key Vault permission on secrets that allows a single secret to be read; App Service Key Vault references need nothing beyond it.
Related terms
- Ranking functions
The T-SQL window functions ROW_NUMBER, RANK, DENSE_RANK and NTILE, which assign numbers to rows in each partition according to the ORDER BY in their OVER clause.