White Papers
SQL Server 2005 Gives Microsoft IT Document Group 7 Times Faster Full-Text Cataloging
Overview Microsoft created a 2.1 terabyte relational database, which grows about 1 terabyte a year, to store, search, and retrieve some 3.5 million documents. To enhance performance, the company upgraded its document management database to Microsoft SQL Server 2005 from SQL Server 2000. Using exactly the same hardware and configurations, the company found 7 times faster full-text cataloging, and 3 times faster full-text searches compared with SQL Server 2000. The company has also enjoyed faster backups. Migration was seamless, and the company didn't have to make any changes to stored procedures, tables, views, triggers, or other code. SQL Server 2005 works seamlessly with computers running SQL Server 2000.
| Publisher | Microsoft | File Format | WORD |
|---|---|---|---|
| Date Published | February 2007 | ||
| Format | Case Studies | ||
| Topics |
|
||



