Intelligent Query Processing-Approximate count distinct in Microsoft SQL Server

Intelligent Query Processing - Approximate count distinct in Microsoft SQL Server
Microsoft introduced the new APPROX_COUNT_DISTINCT feature in Microsoft SQL Server 2019 to speed up the approximate counting of unique values in a large data set and save query resources. In this session, we will compare the performance and algorithm of this feature with the alternative options for counting unique values.

Torsten Strauss
Torsten (MVP, MCSE, MCT) has been working with Microsoft SQL Server since the turn of the millennium and is specialized in performance optimization for large SQL Server environments.
He has been with bp as a database engineer for over two decades and collaborates closely with Sarpedon Quality Lab as a Principal Microsoft SQL Server Consultant.
Torsten is the founder of inside-sqlserver.com and has given more than 190 presentations on Microsoft SQL Server performance optimization at national and international conferences and user groups.
Torsten has been recognized as a Microsoft Most Valuable Professional for Data Platform since 2018.