Microsoft SQL Server: Case Studies

SQL Server in Professional Services

See how companies are using SQL Server to run their most demanding applications, make better decisions, and get faster results. Read more SQL Server 2005 case studies. Or, search the Microsoft Case Studies site to find examples that are relevant to your business.

OLTP

SQL Server 2005 Exceeds Needs for Global Warehouse Management.SQL Server 2005 (64-bit) was processing more than 550,000 order lines per hour, it was executing up to 11,000 Transaction SQL (T-SQL) statements per second

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.

Faster Searches of 1 Terabyte of Litigation Documents Gained with SQL Server 2005

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.

ISV Sees 300 Percent Revenue Increase with Partner Program Support, Technology Switch

When Just OnePlace evaluated its operations, the independent software vendor realized the significant benefits of moving from IBM and Lotus to Microsoft® technologies. The company made the switch and joined the Microsoft Partner Program, which opened doors for its technical and business staff. Since joining the program, Just OnePlace has experienced a 300 percent revenue growth and an enthusiastic response from customers and shareholders.