TotallySQL.com launches suite of function libraries for MS SQL Server

ABINGDON, ENGLAND, May 15, 2011 (Press-News.org) MS SQL Server specialist Totallysql.com has launched an exciting new range of products for developers, data analysts and solutions providers who are using MS SQL Server within their application architecture. These products extend the native functionality of the T-SQL scripting language through the addition of new functions, aggregates and types that enable advanced processing to be carried out within the database layer.

"Carrying out processing within the database has a number of advantages over just storing the data there," said Managing Director, Charles Southey. "Firstly, the data doesn't have to be shuttled backwards and forwards across the network anything like as much - which can mean a massive improvement in application performance and a drastic reduction in network load. Secondly, it enables the application to take advantage of the awesome processing efficiency of the MS SQL database engine, which can process millions of data rows incredibly quickly - it can seem instantaneous."

"All too often you encounter poorly architected applications that pull entire datasets off the database a row at a time for processing on the client - when ultimately all that's needed is a handful of values as the final result. That leads to slow, unresponsive applications - which are also unreliable as operations time out - and very frustrated users. Tuning or adding more power to the database in these situations can only help to a limited extent because the real bottleneck is in architecture itself. Instead, by moving more of the logic into the database and eliminating the pointless chatter and data loading across the network, performance improvements of several orders of magnitude can be achieved."

"Where our products help is by enabling richer business and data processing logic to be built into scripts and stored procedures that reside on the database, whilst keeping the syntax in those scripts clean, elegant and easy to maintain. They're incredibly fast and accurate too - there's no observable difference in performance compared with the built-in native functions. Where there's complex numeric processing to be done (such as in some of our mathematical functions) we've researched extensively for the fastest and most reliable algorithms available, and taken great care to deal properly with the limits of machine precision."

As well as off-the-shelf products in areas such as math, statistics, financial analysis, engineering, text-processing and date/time arithmetic, TotallySQL.com can provide fully-supported bespoke function libraries to order, and a range of other services to help customers exploit the power of the database.

About Totallysql.com

TotallySQL.Com is a specialist provider of MS SQL Server function libraries, management tools and services. It is headquartered in Oxford, UK. More information is available at http://www.totallysql.com.