Provide approximate COUNT DISTINCT for big data scenarios with the benefit of high performance and a low memory footprint.. GeoPITS brings you the comprehensive details of Intelligent Database: approximate count distinct's support in different versions & editions of SQL Server.
Version | Enterprise | Standard | Web | Express (Adv.) | Express |
---|---|---|---|---|---|
Version v2019 | Yes | Yes | Yes | Yes | Yes |
Version v2017 | |||||
Version v2016 | |||||
Version v2014 | |||||
Version v2012 |
Provide approximate COUNT DISTINCT for big data scenarios with the benefit of high performance and a low memory footprint.
You can find more details about this version here