World's 2nd Largest HMO Moves 2-Terabyte BI Data Warehouse to SQL Server 2008

Overview

Clalit Health Services serves more than 3.8 million people, and supports 70 million customer interactions per year. Clalit uses the Microsoft Application Platform to support some 16 terabytes of data, including a 2.7-terabyte Business Intelligence (BI) solution that serves as a repository for clinical and operational information. Clalit's Enterprise BI Data Warehouse has become so important to healthcare professionals and clinic managers that the company decided on an early upgrade to Microsoft SQL Server 2008 Enterprise to take advantage of new features including data compression; enhanced star join functionality to improve query performance; the Resource Governor, to help protect query performance; and support for spatial data types to help Clalit incorporate geographic and related data in planning service delivery.