Microsoft SQL Server Customer Solution Case Study First American Title Insurance Runs Application on SQL Server 2008 “With SQL Server 2008, we’ve been able to implement Overview Country or Region: United States Online Indexing on 99 percent of our tables, gaining a Industry: Financial Services 96 percent reduction in the time required for offline Customer Profile Based in Santa Ana, California, First American Title Insurance Company is the Lianne Kwock, Senior Database Administrator, First American Title Insurance Company second largest title company in the One of the largest title insurance companies in the nation, First United States. American Title Insurance Company, a subsidiary of The First Business Situation American Corporation, traces its history back to 1889. The First American Title Insurance Company needed an enterprise-grade solution to company offers title services through its direct operations and support its mission-critical First American an extensive network of agents throughout the United States Software Technology (FAST) application and its 10-terabytes of data. and abroad. Over the years, First American acquired several companies, leading to a complex IT environment that at one Solution The company upgraded its FAST point had more than 50 different title and escrow systems. The application database to Microsoft SQL company united these disparate systems with its First American Server 2008 Enterprise (64-bit) to take advantage of enhanced Online Indexing, Software Technology (FAST) solution, deployed on the Microsoft Table Partitioning, and other features. Application Platform, recently upgrading its FAST solution to Benefits Microsoft SQL Server 2008 and making use of features such as 96 percent reduction in scheduled Online Indexing and Table Partitioning. The company stores 10 downtime for re-indexing 400 percent improvement for table terabytes of information on SQL Server 2008, with 900 million partitioning rows in the largest table. Easier troubleshooting Enterprise-grade scalability
Microsoft SQL Server Customer Solution Case Study First American Title Insurance Runs Application on SQL Server 2008 Overview Country or Region: United States Industry: Financial Services Customer Profile Based in Santa Ana, California, First American Title Insurance Company is the second largest title company in the United States. Business Situation First American Title Insurance Company needed an enterprise-grade solution to support its mission-critical First American Software Technology (FAST) application and its 10-terabytes of data. Solution The company upgraded its FAST application database to Microsoft SQL Server 2008 Enterprise (64-bit) to take advantage of enhanced Online Indexing, Table Partitioning, and other features. Benefits 96 percent reduction in scheduled downtime for re-indexing 400 percent improvement for table partitioning Easier troubleshooting Enterprise-grade scalability “With SQL Server 2008, we’ve been able to implement Online Indexing on 99 percent of our tables, gaining a 96 percent reduction in the time required for offline Lianne Kwock, Senior Database Administrator, First American Title Insurance Company One of the largest title insurance companies in the nation, First American Title Insurance Company, a subsidiary of The First American Corporation, traces its history back to 1889. The company offers title services through its direct operations and an extensive network of agents throughout the United States and abroad. Over the years, First American acquired several companies, leading to a complex IT environment that at one point had more than 50 different title and escrow systems. The company united these disparate systems with its First American Software Technology (FAST) solution, deployed on the Microsoft Application Platform, recently upgrading its FAST solution to Microsoft SQL Server 2008 and making use of features such as Online Indexing and Table Partitioning. The company stores 10 terabytes of information on SQL Server 2008, with 900 million rows in the largest table.
FirstAmericanSQLServer2008CaseStudy061710.docx