High Performance Statistical Queries
SQL Server Database Engine has so many business intelligence improvements that it might become your primary analytical database system. However, in order to get the maximum out of these features, you need to learn how to properly use them. This in-depth session shows some extremely efficient inventive algorithms for the statistical queries. The queries use Window functions, CLR aggregate functions, and other SQL Server capabilities. The session also explains the formulas and usage of those statistical procedures. This session is useful not only for BI developers; database and other developers can successfully learn how to write efficient queries as well.