Community

SQL SERVER – APPROX_COUNT_DISTINCT – Not Always Efficient

(Pinal Dave) One thing I keep on telling my clients that it is not that always recommended to use the latest feature without proper testing. I was recently hired by clients to help them with tuning a query for SQL Server 2019 Comprehensive Database Performance Health Check.