I have a data warehouse database and I'm facing problems with the new cardinality estimator of SQL Server 2014. After upgrading the database server to SQL Server 2014 I have observed a big differe...

The HyperLogLog algorithm by Flajolet et al describes a clever way to estimate the cardinality of a set using only a tiny amount of memory. However, it does take into account all N elements of th...