O'Reilly logo

Microsoft SQL Server 2008 R2 Administration Cookbook by Satya Shyam K Jayanty

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

SQL Server 2008 R2 Parallel Data Warehouse

The SQL Server 2008 R2 Parallel Data Warehouse (PDW) is built upon a data warehouse technology that takes advantage to improve the reliability and performance of the instance that is highly scalable and built on a Massive Parallel Processing (MPP) and Symmetric Multi-processing (SMP) architecture to enable better administration, scalability of predictable performance, and reduced risk and lower cost per terabyte storage support with major hardware partner compatibility.

PDW provides the scalability and query performance by running independent servers in parallel, which means adding a CPU or memory capacity to the server is a straightforward process. SMP offers the ease of administration and MPP offers ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required