Chapter 2. Implementing a Data Warehouse
Exam objectives in this chapter:
Design and Implement a Data Warehouse
Design and implement dimensions.
Design and implement fact tables.
After learning about the logical configuration of a data warehouse schema, you need to use that knowledge in practice. Creating dimensions and fact tables is simple. However, using proper indexes and partitioning can make the physical implementation quite complex. This chapter discusses index usage, including the new Microsoft SQL Server 2012 columnstore indexes. You will also learn how to use table partitioning to improve query performance and make tables and indexes more manageable. You can speed up queries with pre-prepared aggregations by using indexed views. If you use ...