SQLRollingStats - Summary

Overview | Pricing & Licensing | Evals & Downloads | Compatibility | Publisher Details | Reviews | Support Forum | Summary

Summary

SQLRollingStats by TotallySQL

URLs: sqlrollingstats, totallysql

Compute running totals, moving averages, and many other statistics that need relative row references, within T-SQL queries. SQLRollingStats is a solution for SQL Server that extends and enhances your T-SQL programming environment by adding 30+ statistical window functions - allowing the computation of results per row that depend on values in other rows. All functions are capable of taking into account all rows so far processed, or just the last n rows where n is the specified window size. Functions include: sum, product, maximum, minimum, range, mid-range, first (in sequence), nth previous, average (mean), variance (sample & population), standard deviation (sample & population), geometric mean, harmonic mean, quadratic mean, median, quartile, inter-quartile range, tri-mean, percentile, percentile rank, exponential average (mean), exponential variance, exponential standard deviation, weighted average, weighted variance (sample & population), weighted standard deviation (sample & population), weighted power mean.

Easy to Use

All SQLRollingStats functions are implemented as types: you need only declare a variable of the appropriate type, assign it a starting value (usually '0') and then call its Result() method in your queries using the syntax @variable.Result(), specifying the input values and a row-number (since almost all forms of rolling statistics are only valid when processed in a given order). T-SQL's built-in ROW_NUMBER() function will usually suffice for the purpose - see the examples given in the Product Documentation for more details.

Support for Tiling

Just as the built-in T-SQL ranking functions such as ROW_NUMBER() support tiling (the ability to group results into distinct blocks and re-start the calculation from scratch at the start of each block) using the PARTITION BY clause, so do the SQLRollingStats functions - so you can in a single query calculate rolling statistics across a number of different domains.

Outstanding Performance and Numerical Accuracy

The algorithms behind the SQLRollingStats functions use industry-proven, best-in-class techniques devised by some of the world's leading numerical computing experts to maximise performance and accuracy even for fairly extreme input values. Careful heuristics and edge-case checks through the code ensure that problems caused by the limitations of floating-point arithmetic on digital computers (such as cancellation errors) are kept to an absolute mininum, and a broad range of special-purpose, high-performance numerical computing approaches are used in place of the slow, expensive computations that would result from 'naive' implementations of the underlying mathematics.

SQLRollingStats Features

30+ scalar functions that return results based on data from current row and prior rows in the same query.All functions support a rolling window that discards older values, or can be cumulative (no window)

All functions support tiling (accumulation of data restarts when input row number restarts from 1)

All functions provide checking & enforcement of row-processing order using row number inputs

Sum and product

Maximum, minimum, range and mid-range

First (for a window size of n will return input from n rows ago) and Previous (value from prior row)

Average (mean), sample & population variance, sample & population standard deviation

Geometric mean, harmonic mean, quadratic mean

Weighted average, sample & population variance, sample & population standard deviations.

Exponentially weighted average, variance and standard deviations

Weighted power mean (generalized mean)

Median, quartile, inter-quartile range, tri-mean

Percentile & percentile rank

Compute running totals, moving averages, and many other statistics that need relative row references, within T-SQL queries.

Pricing: SQLRollingStats - CAL (Client Access License) V1.0 1 CAL License, SQLRollingStats - CAL (Client Access License) V1.0 5 CAL License, SQLRollingStats - CAL (Client Access License) V1.0 10 CAL License, SQLRollingStats - CAL (Client Access License) V1.0 25 CAL License, SQLRollingStats - CAL (Client Access License) V1.0 50 CAL License, SQLRollingStats - CAL (Client Access License) V1.0 with - 1 Year Support & Maintenance 1 CAL License, SQLRollingStats - CAL (Client Access License) V1.0 with - 1 Year Support & Maintenance 5 CAL License, SQLRollingStats - CAL (Client Access License) V1.0 with - 1 Year Support & Maintenance 10 CAL License, SQLRollingStats - CAL (Client Access License) V1.0 with - 1 Year Support & Maintenance 25 CAL License, SQLRollingStats - CAL (Client Access License) V1.0 with - 1 Year Support & Maintenance 50 CAL License, SQLRollingStats - CAL (Client Access License) V1.0 with - 3 Year Support & Maintenance 1 CAL License, SQLRollingStats - CAL (Client Access License) V1.0 with - 3 Year Support & Maintenance 5 CAL License, SQLRollingStats - CAL (Client Access License) V1.0 with - 3 Year Support & Maintenance 10 CAL License, SQLRollingStats - CAL (Client Access License) V1.0 with - 3 Year Support & Maintenance 25 CAL License, SQLRollingStats - CAL (Client Access License) V1.0 with - 3 Year Support & Maintenance 50 CAL License, SQLRollingStats - CAL (Client Access License) V1.0 with - 5 Year Support & Maintenance 1 CAL License, SQLRollingStats - CAL (Client Access License) V1.0 with - 5 Year Support & Maintenance 5 CAL License, SQLRollingStats - CAL (Client Access License) V1.0 with - 5 Year Support & Maintenance 10 CAL License, SQLRollingStats - CAL (Client Access License) V1.0 with - 5 Year Support & Maintenance 25 CAL License, SQLRollingStats - CAL (Client Access License) V1.0 with - 5 Year Support & Maintenance 50 CAL License, SQLRollingStats CAL (Client Access License) - 1 Year Support & Maintenance Renewal 1 CAL Support & Maintenance Renewal License, SQLRollingStats CAL (Client Access License) - 1 Year Support & Maintenance Renewal 5 CAL Support & Maintenance Renewal License, SQLRollingStats CAL (Client Access License) - 1 Year Support & Maintenance Renewal 10 CAL Support & Maintenance Renewal License, SQLRollingStats CAL (Client Access License) - 1 Year Support & Maintenance Renewal 25 CAL Support & Maintenance Renewal License, SQLRollingStats CAL (Client Access License) - 1 Year Support & Maintenance Renewal 50 CAL Support & Maintenance Renewal License, SQLRollingStats CAL (Client Access License) - 3 Year Support & Maintenance Renewal 1 CAL Support & Maintenance Renewal License, SQLRollingStats CAL (Client Access License) - 3 Year Support & Maintenance Renewal 5 CAL Support & Maintenance Renewal License, SQLRollingStats CAL (Client Access License) - 3 Year Support & Maintenance Renewal 10 CAL Support & Maintenance Renewal License, SQLRollingStats CAL (Client Access License) - 3 Year Support & Maintenance Renewal 25 CAL Support & Maintenance Renewal License, SQLRollingStats CAL (Client Access License) - 3 Year Support & Maintenance Renewal 50 CAL Support & Maintenance Renewal License, SQLRollingStats CAL (Client Access License) - 5 Year Support & Maintenance Renewal 1 CAL Support & Maintenance Renewal License, SQLRollingStats CAL (Client Access License) - 5 Year Support & Maintenance Renewal 5 CAL Support & Maintenance Renewal License, SQLRollingStats CAL (Client Access License) - 5 Year Support & Maintenance Renewal 10 CAL Support & Maintenance Renewal License, SQLRollingStats CAL (Client Access License) - 5 Year Support & Maintenance Renewal 25 CAL Support & Maintenance Renewal License, SQLRollingStats CAL (Client Access License) - 5 Year Support & Maintenance Renewal 50 CAL Support & Maintenance Renewal License, SQLRollingStats - CPU License V1.0 1 CPU License, SQLRollingStats - CPU License V1.0 2 CPU License, SQLRollingStats - CPU License V1.0 4 CPU License, SQLRollingStats - CPU License V1.0 8 CPU Licens

Evals & Downloads: Read the SQLStatistics help file, Read the TotallySQL License Agreement, Download the SQLStatistics V1.0 evaluation on to your computer - Expires After 30 Days

Operating System for Deployment: Windows 7, Windows Server 2008, Windows Server 2003

Architecture of Product: 32Bit, 64Bit

Product Type: Component

Component Type: .NET Class, 100% Managed Code

Compatible Containers: Microsoft SQL Server 2008, Microsoft SQL Server 2005

Keywords: SQLRollingStats

totally sql

Math Stats Mathematics Mathematical Statistic Statistical

SQL query language

Part numbers: PC-541772-407596 541772-407596 PC-541772-407597 541772-407597 PC-541772-407598 541772-407598 PC-541772-407599 541772-407599 PC-541772-407600 541772-407600 PC-541772-407601 541772-407601 PC-541772-407602 541772-407602 PC-541772-407603 541772-407603 PC-541772-407604 541772-407604 PC-541772-407605 541772-407605 PC-541772-407606 541772-407606 PC-541772-407607 541772-407607 PC-541772-407608 541772-407608 PC-541772-407609 541772-407609 PC-541772-407610 541772-407610 PC-541772-407611 541772-407611 PC-541772-407612 541772-407612 PC-541772-407613 541772-407613 PC-541772-407614 541772-407614 PC-541772-407615 541772-407615 PC-541772-407616 541772-407616 PC-541772-407617 541772-407617 PC-541772-407618 541772-407618 PC-541772-407619 541772-407619 PC-541772-407620 541772-407620 PC-541772-407621 541772-407621 PC-541772-407622 541772-407622 PC-541772-407623 541772-407623 PC-541772-407624 541772-407624 PC-541772-407625 541772-407625 PC-541772-407626 541772-407626 PC-541772-407627 541772-407627 PC-541772-407628 541772-407628 PC-541772-407629 541772-407629 PC-541772-407630 541772-407630 PC-541772-407876 541772-407876 PC-541772-407877 541772-407877 PC-541772-407878 541772-407878 PC-541772-407879 541772-407879 PC-541772-407880 541772-407880 PC-541772-407881 541772-407881 PC-541772-407882 541772-407882 PC-541772-407883 541772-407883 PC-541772-407884 541772-407884 PC-541772-407885 541772-407885 PC-541772-407886 541772-407886 PC-541772-407887 541772-407887 PC-541772-407888 541772-407888 PC-541772-407889 541772-407889 PC-541772-407890 541772-407890 PC-541772-407891 541772-407891 PC-541772-407892 541772-407892 PC-541772-407893 541772-407893 PC-541772-407894 541772-407894 PC-541772-407895 541772-407895 PC-541772-407896 541772-407896 PC-541772-407897 541772-407897 PC-541772-407898 541772-407898 PC-541772-407899 541772-407899 PC-541772-407900 541772-407900 PC-541772-407901 541772-407901 PC-541772-407902 541772-407902 PC-541772-407903 541772-407903 PC-541772-407904 541772-407904 PC-541772-407905 541772-407905 PC-541772-407906 541772-407906 PC-541772-407907 541772-407907 PC-541772-407908 541772-407908 PC-541772-407909 541772-407909 PC-541772-407910 541772-407910