About Total SQL Statistics - for SQL Server 7.0/2000

Perform a wide range of statistical functions with all results in SQL Server tables.

Total SQL Statistics is a Windows application that offers a wide range of statistical functions for Visual Basic and Visual Studio.Net developers using SQL Server data. It includes functions to analyze data stored in SQL Server tables, views, stored procedures, and user defined functions. Total SQL Statistics can generate Visual Basic.Net code that runs any scenario you have defined.

Developed specifically for Visual Basic and Visual Studio.Net developers using SQL Server data, Total SQL Statistics eliminates the need to export your data to other programs for statistical analysis. You can perform a wide range of statistical functions with all results in SQL Server tables. View, sort, query, or display the results.

Total SQL Statistics includes two parts. The first is an interactive Statistics Scenario Designer. This standalone program lets you easily specify the database, data, fields, and analysis to perform. The second part is a DLL component that performs the analysis. Design analysis scenarios by running our standalone Scenario Designer program, and run them from your program with a simple DLL call into a distributable run-time library. Only the structure of the scenario is saved, not the data, so analysis is always performed on the current data.

Total SQL Statistics supports Microsofts .Net platform. You can create Visual Studio.Net projects and include a reference to the Total SQL Statistics Runtime DLL just as you would in Visual Basic 6. Additionally, Total SQL Statistics can generate Visual Basic.Net code that runs any scenario you have defined.

Scenario Designer

The Total SQL Statistics Scenario Designer is where you create analysis scenarios. Scenarios contain information on the data to analyze and the statistical options to perform. A Wizard-like interface guides you through the process with no programming required. This allows you to perform powerful analysis with point-and-click ease. Your selections are automatically saved as "scenarios" which can be run interactively or invoked programmatically.

Programmatic Interface

Total SQL Statistics includes a programmatic interface for programmers who want to incorporate statistical functions directly into their applications. A DLL is all that is needed to add Total SQL Statistics to your applicationssimply reference our DLL with the scenario you designed in the Scenario Designer, and the results are generated. You can specify all login information and direct output tables to a different database. While the analysis is running, events are available to let you know its progress. The analysis runs in the background, so your users wont even know how you generate the complex analysis!