FileControl Partners, with its hosted FileControl Knowledge & Litigation Management System, helps Fortune 500 companies and other organizations around the world work with millions of pages of documents. Attorneys needing to research millions of pages of documents need incredibly fast full-text search capabilities to identify relevant information. To enhance search speeds across its more than 2 billion rows of data, FileControl upgraded its combined 1 terabyte of databases to Microsoft® SQL Server™ 2005 (64-bit), replacing its earlier deployment of SQL Server 2000. Since upgrading to SQL Server 2005, the company has enjoyed full-text searches that run 25 times faster than before, and has seen a 300 percent increase in the rate at which it can insert new data. The company also enjoys easier maintenance, as re-indexing that once took three hours is completed in less than 10 minutes.

Based in Milwaukee, Wisconsin, RedPrairie has been helping companies better manage their warehouses for more than 30 years. Although about 95 percent of its customers used to deploy RedPrairie solutions using the UNIX operating system, the trend has reversed in recent years with now more than 70 percent asking for solutions running on Microsoft® Windows Server® 2003 operating system. RedPrairie needed to ensure that even its global customers—processing some 500,000 order lines per day—could run their warehouse management solutions using Microsoft SQL Server™ 2005 Enterprise Edition (64-bit) database. The company tested SQL Server 2005 and found it could support loads of more than 550,000 order lines per hour, it was executing up to 11,000 Transaction SQL (T-SQL) statements per second.

“Reporting Services gives us a tool that integrates with other Microsoft platform products, and it opens up our database to the information needed by the more skilled and demanding end user.” - Jan Willem de Lange, Director of Research and Development, NetEconomy

The reservation system is at the core of an airline’s operations. Navitaire serves some 50 airlines around the globe with its reservation system, including industry leaders such as AirTran Airways, Jetstar, and Ryanair. When Navitaire’s existing reservation system, was approaching the limits of its processing capabilities for some of its largest customers, a change was needed. Navitaire upgraded to a solution using Microsoft® SQL Server™ 2005 Enterprise Edition (64-bit) running on Intel-based 8-CPU 64-bit database servers. To address this need, the company developed a new reservation system, using Microsoft Visual Studio® 2005 and the Microsoft .NET Framework. The solution gave Navitaire the scalability it required, enhanced performance, and simplified database management.

Recall Corporation, a full-service information management company, wanted to make it easy for customers to track and request documents. Recall developed a Web-based application that worked with a Microsoft® SQL Server™ 2000 database solution to provide full-text search (FTS) capabilities. It wasn’t long before the company’s growing databases were too much for its FTS service to handle, leading to downtime, the forced rebuilding of search indexes, and increased customer care costs. To remedy the situation, Recall upgraded to Microsoft SQL Server 2005, which delivered 50 percent faster FTS capabilities, increased the solution’s scalability, and provided improved management tools. With SQL Server 2005 in place, Recall now can serve customers more quickly and without a negative effect on its financial performance.

MLS Property Information Network, the largest MLS firm in New England, wanted to replace an aging, proprietary UNIX system with one that would give it greater flexibility in gathering, collating, and delivering listings information, and allow as many concurrent users as possible to get the information from the firm's subscription-only Web site. It chose to build its application on top of Microsoft Windows Server 2003 with Internet Information Services 6.0, along with SQL Server 2000, because the Microsoft solution offered off-the-shelf simplicity, powerful tools for building applications and analyzing data, flexibility and scalability, easy maintenance, and high reliability and availability. The entire project is projected to yield nearly U.S.$7 million in benefits and provided MLS Property Information Network with a platform it can use to easily build new products and services.