Our internal partners have learned that if the job is really complex or if you need it done very quickly, our SQL Server 7.0 database can easily get you what you need. Outside the 50 United States and Canada, please contact your local Microsoft office. However, when one of the finance groups anticipated performing a large number of complex queries against this database, managers at PCS were concerned that this would compromise responsiveness for the hundreds of other users who needed access to the data. By running queries against the single 1.3-terabyte SQL Server database, the group could ensure a responsive environment for their own project without compromising the performance of the DB2 system for other users in the company. PCS managers discovered that the SQL Server-based data warehouse is highly responsive, even at 1.3 terabytes in size.
Complex queries take only minutes, even on record sets that include millions of records.
The success of this experiment has inspired the deployment of individual SQL Server-based data marts for six different groups within PCS, enabling significantly faster access to information. All rights reserved. Terms of Use.