SQL Server 2019 : APPROX_COUNT_DISTINCT
This new approximate function may not cut down on execution time, but it relieves a whole lot of memory pressure.
This new approximate function may not cut down on execution time, but it relieves a whole lot of memory pressure.